From: bruce <bedouglas@earthlink.net>
To: 'Jean-Christian Imbeault' <jc@mega-bucks.co.jp>
To: christoph.dellavalle@goetheanum.ch
To: 'pgsql-novice' <pgsql-novice@postgresql.org>
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> (raw)
In-Reply-To: <3F24CEDB.6040300@mega-bucks.co.jp>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: bedouglas@earthlink.net, jc@mega-bucks.co.jp, christoph.dellavalle@goetheanum.ch, pgsql-novice@postgresql.org
Subject: Re: Accessing Postgres db from apache using PHP
In-Reply-To: <003b01c35525$cf5dfca0$0301a8c0@Mesa.com>
References: <3F24CEDB.6040300@mega-bucks.co.jp> <003b01c35525$cf5dfca0$0301a8c0@Mesa.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox