php5 and postgresql 8.2/8.3

[Jeremy Chadwick]

On Thu, Apr 17, 2008 at 02:05:27PM +0200, Claus Guttesen wrote:
> I have installed php5 with support for postgresql (php5-pgsql). If I
> install postgresql-client ver. 8.2.7 or 8.3.x apache (httpd)
> core-dumps. If I install postgresql-client 8.1.11 or 8.2.6 apache does
> not core-dump.
> 
> This is the output (backtrace) from gdb:
> 
> (gdb) bt
> #0  0x000000080651c340 in ?? ()
> #1  0x000000080094ebd5 in puts () from /lib/libc.so.7
> #2  0x000000080094f1ee in gethostbyname () from /lib/libc.so.7
> #3  0x000000000041ee80 in ap_get_local_host ()
> #4  0x000000000041e131 in ap_fini_vhost_config ()
> #5  0x000000000040de35 in ap_read_config ()
> #6  0x00000000004156f1 in standalone_main ()
> #7  0x0000000000416e2c in main ()
> 
> I have confirmed that it's postgresql which makes apache core dump by
> commenting out pgsql.so in /usr/local/etc/php/extensions.ini. This -
> off-course - prevents me from connecting to my db. :-/
> 
> Apache is ver. 1.3.41 from ports with no changes to the default-values
> during portinstall. PHP is ver. 5.2.5_1.

Last night I migrated one of my machines from mysql51 to postgresql83,
which included adding php5-pgsql to my extensions list.  I have
absolutely no problems.  I'm using Apache 2.2, however.

$ pkg_info | egrep 'apache|php5-pgsql|postgres'
apache-2.2.8        Version 2.2 of Apache web server with prefork MPM.
php5-pgsql-5.2.5_1  The pgsql shared extension for php
postgresql-client-8.3.1 PostgreSQL database (client)
postgresql-server-8.3.1 The most advanced open-source database available anywhere

-- 
| Jeremy Chadwick                                    jdc at parodius.com |
| Parodius Networking                           http://www.parodius.com/ |
| UNIX Systems Administrator                      Mountain View, CA, USA |
| Making life hard for others since 1977.                  PGP: 4BD6C0CB |