Skip site navigation (1) Skip section navigation (2)

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

From: "Hano de la Rouviere" <hano(at)linutech(dot)co(dot)za>
To: "KRB" <krboden(at)mhm-law(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How can I tell what port my postgreSQL server is running on?
Date: 2002-07-15 13:39:52
Message-ID: 004e01c22c05$18be79b0$05faa8c0@edios (view raw or flat)
Thread:
Lists: pgsql-novice
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
>


In response to

pgsql-novice by date

Next:From: Josh JoreDate: 2002-07-15 14:46:15
Subject: Re: removing specific duplicates
Previous:From: Aarni Ruuhimäki / Megative Tmi / KYMI.comDate: 2002-07-15 11:54:53
Subject: Re: Newbie Stupid Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group