Re: Persistent Connects (pg_pconnect) - Mailing list pgsql-sql

From Keith Wong
Subject Re: Persistent Connects (pg_pconnect)
Date
Msg-id 4.3.2.7.0.20001122002920.00b9c158@mail.e-magine.com.au
Whole thread Raw
In response to Persistent Connects (pg_pconnect)  (Colleen Williams <colleen@digital-arts.co.uk>)
List pgsql-sql
Just looked at the Php documentation... according to that.. it goes...

"An 'identical' connection is a connection that was opened to the same 
host, with the same username and the same password (where applicable)."

Perhaps that means you need to specify the host for this to work.

Let me know on your findings. I'll be interested to know.

Cheers,
Keith :)


At 12:34 PM 21/11/2000 +0000, Colleen Williams wrote:
>Hello all,
>
>I am having some problems with persistent connections.
>
>The PHP scripts in my content management system (CMS) are connecting using 
>pg_pconnect(" dbname='MYDB' user='user' password='password'' 
>port='5432'  "). I have not been able to connect to the PostgreSQL 
>database when I include the host parameter in the pg_pconnect string and I 
>don't understand why. Each time one of us uses the CMS, a new persistent 
>connection process owned by postgres is started up. With 3 people 
>accessing the CMS sporadically, 32 persistent connections are in existence 
>and then Linux tells me there are too many connections!  Sometimes I 
>believe existing connections are reused but not often!
>
>Has anyone else had this sort of experience with persistent connections? 
>It is driving me mad so I would appreciate any help or pointers you might have.
>
>Thanks,
>Colleen.
>
>Colleen Williams
>colleen@digital-arts.co.uk
>
>0207 484 8825
>
>Digital Arts | British Columbia House | 1 Regent Street | London | SW1Y 4NR
>http://www.digital-arts.co.uk



pgsql-sql by date:

Previous
From: Keith Wong
Date:
Subject: Re: Persistent Connects (pg_pconnect)
Next
From: Keith Wong
Date:
Subject: Re: Blob Upload