Received: from smtp010.mail.yahoo.com (smtp010.mail.yahoo.com [216.136.173.30]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0SFuJl48534 for ; Mon, 28 Jan 2002 10:56:19 -0500 (EST) (envelope-from chrup999@yahoo.com) Received: from chill-025.dfw.tx.bbnow.net (HELO ?192.168.0.6?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 28 Jan 2002 15:56:29 -0000 Mime-Version: 1.0 X-Sender: chrup999@pop.mail.yahoo.com Message-Id: Date: Mon, 28 Jan 2002 09:56:27 -0600 To: PostGreSQL PHP Group From: Chris Ruprecht Subject: pg_pconnect - ?? Content-Type: text/plain; charset="iso-8859-1" ; format="flowed" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id g0SGDmm50676 X-Archive-Number: 200201/74 X-Sequence-Number: 878 Hi all, I am under the assumtion that, when I do a pg_pconnect instead of a pg_connect, the connection to the db I have established, can be used by another PHP procedure. Somehow, I don't see this working the way I expect it. When I initially connect with pconnect, I see a postgres session staring up and everything works. The postgres process stays active but when I pconnect again, a second process is started. I was expecting that the same process from the first pconnect will be used. At the end, I land up with a whole bunch of postgres client sessions hanging around in the system, doing who knows what. What am I missing (doing wrong) here? Postgres = 7.1.3, OS = Linux 2.4.9 (RedHat 7.2), PHP = 4.0.6, Apache = 1.3.22, memory = plenty (768 MB) Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com