X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 09D7952889 for ; Tue, 14 Jun 2005 23:26:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49203-06 for ; Wed, 15 Jun 2005 02:26:06 +0000 (GMT) Received: from smtp.duo-county.com (smtp.duo-county.com [66.38.0.221]) by svr1.postgresql.org (Postfix) with ESMTP id CDF0B52822 for ; Tue, 14 Jun 2005 23:26:02 -0300 (ADT) Received: from localhost.localdomain (14-186.mod.duo-county.com [66.38.14.186]) by bn9.blue.net (8.12.10/8.12.10/SMTP) with ESMTP id j5F2Q1cY025814 for ; Tue, 14 Jun 2005 21:26:02 -0500 (CDT) Received: from dlb by localhost.localdomain with local (Exim 4.50) id 1DiNbQ-0000S4-A4 for pgsql-admin@postgresql.org; Tue, 14 Jun 2005 21:26:04 -0500 Date: Tue, 14 Jun 2005 21:26:03 -0500 To: pgsql-admin@postgresql.org Subject: Connecting via localhost pg-8.0.3 Message-ID: <20050615022603.GA1615@localhost.localdomain> Mail-Followup-To: pgsql-admin@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Mutt/1.5.9i From: David X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.117 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/94 X-Sequence-Number: 17849 I'm not sure to what list this question belongs, but here goes. I've just upgraded from 7.4.7 to 8.0.3. All seems to have upgraded well but I've stumbled across one thing I don't understand. It now seems that I have to include host=3Dlocalhost in the pg_connect params from a php script, whereas these same scripts without this specification worked with 7.4.7. I get the following error if I omit "host=3Dlocalhost" : Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: =B8^@Hv@' Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? in /home/dlb/public_html/test.php on line 2 I notice that it appears from the above that without the host specification, the server name comes across as garbage. Again, adding the host specification eliminates the error. In my postgresql.conf file, I have the line: listen_addresses =3D '*' the php manual says that you need the '-i' option, but from the 8.0- docs, it states that the -i option is deprecated and the above line takes care of it. This is no show-stopper, just a matter of editing a few lines in my php files, but I'm just wondering if it's a config parameter on my part or a change in postgres' default behavior. My php (4.3.10) hasn't been upgraded for some time, so it shouldn't be in php.