Skip site navigation (1) Skip section navigation (2)

Re: pg_pconnect - ??

From: Chadwick Rolfs <cmr(at)shell(dot)gis(dot)net>
To: Chris Ruprecht <chrup999(at)yahoo(dot)com>
Cc: PostGreSQL PHP Group <pgsql-php(at)postgresql(dot)org>
Subject: Re: pg_pconnect - ??
Date: 2002-01-28 20:50:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-php
Aside from Apache children, pconnect doesn't really have any advantage
over connect... straight from the doc...
You can use $GLOBALS to pass connections instead of trying to use the
pconnect string over and over.

If you write a quick function _one_ function that checks to see if a
connection is made, and uses that resource - or makes a new one, then all
you should have to do is include() that function in each one of your

Do you need an example?  Send us one of yours, and we'll show you (at
least I will).  I'd like to see what exactly you're using the pconnect


On Mon, 28 Jan 2002, Chris Ruprecht wrote:

> 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 extraordinare
> _________________________________________________________
> Do You Yahoo!?
> Get your free address at
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

Chadwick Rolfs - cmr(at)gis(dot)net
Cleveland State University - Student
Music Major - The Holden Arboretum Volunteer
Computer Programmer - Student Employee
--*I finally found powdered water;
I just can't figure out what to add to it*--

In response to

pgsql-php by date

Next:From: Chadwick RolfsDate: 2002-01-28 21:07:17
Subject: Re: pg_pconnect - ??
Previous:From: Chris RuprechtDate: 2002-01-28 20:31:01
Subject: Re: pg_pconnect - ??

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group