Thread: php 5.1.4 w/ PostgreSQL 8.1.4
The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL 8.1.4 - but could not. The PGSQL extension kills the httpd (Apache 1.3.36). Just went back to PostgreSQL 8.0.8 and all works fine. No idea what it is - just decided to report. Everything was build the usual way from ports on FreeBSD 5.4. Regards, Iv
pobox@verysmall.org wrote: > The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL > 8.1.4 - but could not. The PGSQL extension kills the httpd (Apache > 1.3.36). > > Just went back to PostgreSQL 8.0.8 and all works fine. > > No idea what it is - just decided to report. > > Everything was build the usual way from ports on FreeBSD 5.4. > > Regards, > Iv do you have a reproduce script? I have FreeBSD/amd64 6.1-RELEASE, pg 8.1.4, PHP 5.1.4, Apache 2.2.2 all from ports, playing nicely. Just another data point (yes, I know the apache is different, but...). LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: Larry.Rosenman@pervasive.com Web: www.pervasive.com
For what it's worth, I have no issue with PHP 5.1.4 and PostgreSQL 8.1.4 on Gentoo either. Gavin On Jun 5, 2006, at 2:40 PM, Larry Rosenman wrote: > pobox@verysmall.org wrote: >> The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL >> 8.1.4 - but could not. The PGSQL extension kills the httpd (Apache >> 1.3.36). >> >> Just went back to PostgreSQL 8.0.8 and all works fine. >> >> No idea what it is - just decided to report. >> >> Everything was build the usual way from ports on FreeBSD 5.4. >> >> Regards, >> Iv > do you have a reproduce script? > > I have FreeBSD/amd64 6.1-RELEASE, pg 8.1.4, PHP 5.1.4, Apache 2.2.2 > all > from > ports, playing nicely. > > Just another data point (yes, I know the apache is different, but...). > > LER > > -- > Larry Rosenman > Database Support Engineer > > PERVASIVE SOFTWARE. INC. > 12365B RIATA TRACE PKWY > 3015 > AUSTIN TX 78727-6531 > > Tel: 512.231.6173 > Fax: 512.231.6597 > Email: Larry.Rosenman@pervasive.com > Web: www.pervasive.com > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match
On Mon, Jun 05, 2006 at 11:34:35PM +0200, pobox@verysmall.org wrote: > The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL 8.1.4 - > but could not. The PGSQL extension kills the httpd (Apache 1.3.36). > > Just went back to PostgreSQL 8.0.8 and all works fine. Maybe you should check that you're linking against the libraries you think you are. For example, run ldd over both apache and the pgsql module and check they have similar ideas as to which libraries they're using. Make sure you don't have multiple copies of postgres installed, or multiple copies of any libraries it might use... Hope this helps, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment
> Maybe you should check that you're linking against the libraries you > think you are. For example, run ldd over both apache and the pgsql > module and check they have similar ideas as to which libraries they're > using. > > Make sure you don't have multiple copies of postgres installed, or > multiple copies of any libraries it might use... > > Hope this helps, Thanks everybody for the help. I lost 2-3 days trying and I went back go 8.0.8 in order to be able to work, but I'll make the suggested test the following weekend. Regards, Iv.