On Thu, 2003-07-31 at 00:56, b b wrote:
> What port does the postgresql server listen on. I am
> trying to connect using pg_connect from php using port
> 5432 with the following command:
> $dbconn3 = pg_connect ("host=localhost port=5432
> dbname=dbname user=myname password=mypass");
>
> I get the following:
> 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? ...
>
> How do we know the port postgresql is listening on?
This should help:
$ netstat -a |grep postgresql
--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: [EMAIL PROTECTED] |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
