pg_pconnect - ??

From: Chris Ruprecht <chrup999(at)yahoo(dot)com>
To: PostGreSQL PHP Group <pgsql-php(at)postgresql(dot)org>
Subject: pg_pconnect - ??
Date: 2002-01-28 15:56:27
Message-ID: p0510120cb87b23a62b3d@[192.168.0.6]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Chris Thompson 2002-01-28 16:51:17 Re: pg_pconnect - ??
Previous Message Josh Berkus 2002-01-26 00:27:31 Re: Long running queries and timeouts