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

Re: Persistent Connects (pg_pconnect)

From: Keith Wong <keith(at)e-magine(dot)com(dot)au>
To: Colleen Williams <colleen(at)digital-arts(dot)co(dot)uk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Persistent Connects (pg_pconnect)
Date: 2000-11-21 13:31:09
Message-ID: 4.3.2.7.0.20001122002920.00b9c158@mail.e-magine.com.au (view raw or flat)
Thread:
Lists: 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(at)digital-arts(dot)co(dot)uk
>
>0207 484 8825
>
>Digital Arts | British Columbia House | 1 Regent Street | London | SW1Y 4NR
>http://www.digital-arts.co.uk


In response to

pgsql-sql by date

Next:From: Keith WongDate: 2000-11-21 13:42:29
Subject: Re: Blob Upload
Previous:From: Keith WongDate: 2000-11-21 13:25:22
Subject: Re: Persistent Connects (pg_pconnect)

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