Re: Persistent Connects (pg_pconnect)

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