X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 02683D1B56B for ; Wed, 3 Sep 2003 17:36:48 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 23305-08 for ; Wed, 3 Sep 2003 14:36:16 -0300 (ADT) Received: from inet0.tonesoft.com (mail.tonesoft.com [12.9.200.149]) by svr1.postgresql.org (Postfix) with ESMTP id 604F1D1B574 for ; Wed, 3 Sep 2003 14:36:15 -0300 (ADT) Received: from VALUED1171C649 ([192.168.2.245]) by inet0.tonesoft.com (8.12.9/8.12.9) with SMTP id h83HaEqt008785 for ; Wed, 3 Sep 2003 10:36:14 -0700 (PDT) From: "Edric Bulalacao" To: Subject: pg_connect problem Date: Wed, 3 Sep 2003 10:36:14 -0700 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001A_01C37207.331F6960" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/5 X-Sequence-Number: 2282 This is a multi-part message in MIME format. ------=_NextPart_000_001A_01C37207.331F6960 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit I’m a PHP/PostGRE newbie. I’m getting this error: Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host localhost and accepting TCP/IP connections on port 5432? . in /export/home/tsc/a/delete-action.phtml on line 156 Couldn't make a connection! This is the code I’m trying to run: $connection = pg_connect("host=localhost dbname=address user=address password=address"); This is my pg_hba.conf local all all password This is the output of “netstat –an | grep 5432” unix 2 [ ACC ] STREAM LISTENING 27649 /tmp/.s.PGSQL.5432 I’m able to do “psql –u address” and supply and username and password as any Unix user defined in the system. Can anyone tell me what I’m doing wrong? Thanks. ------=_NextPart_000_001A_01C37207.331F6960 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I’m a PHP/PostGRE newbie.&nb= sp; I’m getting this error:

 <= /span>

W= arning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host localhost and accepting TCP/IP connections on port 5432? . in /export/home/tsc/a/delete-action.phtml on line 156
Couldn't make a connection!
<= span style=3D'font-family:Arial;color:black;mso-color-alt:windowtext'>

=  

= This is the code I’m trying to= run:

= $connection =3D pg_connect("host=3Dlocalhost dbname=3Daddress user=3Daddress password= =3Daddress");

=  

= This is my pg_hba.conf=

= local  all      all           &nbs= p; password

=  

= This is the output of “netstat= –an | grep 5432”

= unix      [ ACC ]     STREAM     LISTENING     27649  /tmp/.s.PGSQL.5= 432

=  

= I’m able to do “psql = 211;u address” and supply and username and password as any Unix user defined in the system.

=  

=  

= Can anyone tell me what I’m do= ing wrong?  Thanks.=

=  

------=_NextPart_000_001A_01C37207.331F6960--