Re: How can I tell what port my postgreSQL server is running on?

On the server run :

netstat -na

and see if
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN

if not
edit your postgresql.conf in your $PGDATA directory

tcpip_socket = true

Restart your server
That should do it.

http://www.pgexplorer.com

----- Original Message -----
From: "KRB" <krboden(at)mhm-law(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Saturday, July 13, 2002 4:43 AM
Subject: [NOVICE] How can I tell what port my postgreSQL server is running
on?

> I didn't specify one, and it was installed as part of RedHat 7.3, so I'm
guessing its 5432.
>
> My real problem is that MS SQL 7.0 says,
> Could not connect to server.
> Could not connect to remote socket.
>
> I searched the archives, and they said to
> 1) make sure postgreSQL is running by doing a psql <database name>
> 2) Make sure you specify the correct port for your server
>
> the psql thing works fine, and I'm pretty sure the services are up,
network is connected, machines can ping each other.
>
> Thanks
>
> Keith
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>