Re: Accessing Postgres db from apache using PHP

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(at)earthlink(dot)net

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Jean-Christian
Imbeault
Sent: Monday, July 28, 2003 12:21 AM
To: christoph(dot)dellavalle(at)goetheanum(dot)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