X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 63335D1C4EC for ; Mon, 28 Jul 2003 16:27:14 +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 01078-07 for ; Mon, 28 Jul 2003 13:26:17 -0300 (ADT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by svr1.postgresql.org (Postfix) with ESMTP id 2DE32D1C4E8 for ; Mon, 28 Jul 2003 13:27:12 -0300 (ADT) Received: from sys2 (12-232-24-239.client.attbi.com[12.232.24.239](untrusted sender)) by attbi.com (rwcrmhc11) with SMTP id <2003072816271001300nb3lre>; Mon, 28 Jul 2003 16:27:10 +0000 Reply-To: From: "bruce" To: "'Jean-Christian Imbeault'" , , "'pgsql-novice'" Subject: Re: Accessing Postgres db from apache using PHP Date: Mon, 28 Jul 2003 09:32:16 -0700 Message-ID: <003b01c35525$cf5dfca0$0301a8c0@Mesa.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: <3F24CEDB.6040300@mega-bucks.co.jp> Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/205 X-Sequence-Number: 7740 hi.... I just searched my drive... I find the following files: postgresql postgres.conf.sample I do not find a file --> postgres.conf Where should it be/reside.... The information in the postgres.conf.sample has the tcpip_socket parameter !!! This might be the issue!!!!!!!!!!!! Thanks Bruce bedouglas@earthlink.net -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Jean-Christian Imbeault Sent: Monday, July 28, 2003 12:21 AM To: christoph.dellavalle@goetheanum.ch; pgsql-novice Subject: Re: [NOVICE] Accessing Postgres db from apache using PHP >i then do a: > $tmp = "host=localhost dbname=gforge user=gforge >password=gforge"; > $conn = @pg_connect($tmp); Just jumping in here but don't you need to specify the port? $conn = pg_connect("host=localhost port=5432 dbname=gforge user=gforge"); Also, don't use the @, that way you can see any useful error messages that are displayed :) Oh, and you did change the conf file to let postgres use TCP/IP? tcpip_socket = true port=5432 Jc ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend