Received: from qube1.digital-arts.co.uk ([212.121.100.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eALCZps94190 for ; Tue, 21 Nov 2000 07:35:52 -0500 (EST) (envelope-from colleen@digital-arts.co.uk) Received: from COLLEENS_PC.digital-arts.co.uk ([192.168.1.61]) by qube1.digital-arts.co.uk (8.9.3/8.9.2) with ESMTP id MAA16045 for ; Tue, 21 Nov 2000 12:33:44 GMT Message-Id: <4.3.2.7.2.20001121122024.00b41aa8@192.168.1.253> X-Sender: colleen@192.168.1.253 X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Tue, 21 Nov 2000 12:34:19 +0000 To: pgsql-sql@postgresql.org From: Colleen Williams Subject: Persistent Connects (pg_pconnect) Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200011/168 X-Sequence-Number: 199 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