ID: 8769 Updated by: yohgaki Reported By: [EMAIL PROTECTED] Old Status: Open Status: Feedback Bug Type: PostgreSQL related Operating System: RedHat 7.0/Linux 2.2.16 x86 PHP Version: 4.0.4pl1 New Comment:
Status => feedback Previous Comments: ------------------------------------------------------------------------ [2001-12-05 18:36:27] [EMAIL PROTECTED] Does this happen with 4.1.0RC5? http://www.php.net/~zeev/php-4.1.0RC5.tar.gz ------------------------------------------------------------------------ [2001-01-17 23:01:09] [EMAIL PROTECTED] It seems that either the PostgreSQL connections are not killed after the Apache child process exits, or Apache isn't killing children as normal. If I use the dynamically loaded pgsql module, I run into the maximum number of PostgreSQL clients allowed almost immediately, whereas I have never maxed out the number of clients with the pgsql module compiled into the php library directly. Hope that clears it up. ------------------------------------------------------------------------ [2001-01-17 21:46:44] [EMAIL PROTECTED] What do you mean by persistent connections not closing? They are not supposed to close, hence the name. ------------------------------------------------------------------------ [2001-01-17 18:28:51] [EMAIL PROTECTED] When using the PostgreSQL functions that have been compiled as a dynamically loaded module, persistent connections do not seem to close properly. I'm loading the module using the dl() function call within my script. My original configure script was: ./configure \ --with-apxs=/usr/sbin/apxs \ --with-gettext=no \ --with-msql \ --with-pgsql=shared \ --without-mysql \ --without-gd \ --with-xml=shared \ --with-pdflib=/usr/local \ --enable-track-vars=yes \ --with-zlib \ --with-jpeg-dir=/usr \ --with-tiff-dir=/usr \ --with-session=/tmp \ --enable-trans-sid I fixed the problem by removing the "shared" from the --with-pgsql line. ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=8769&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]