Thread: 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

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@mhm-law.com>
To: <pgsql-novice@postgresql.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
>