How to find compiled-in default port number?

On Tue, 2012-03-13 at 11:16 +0200, Виктор Егоров wrote:

Greetings.

Is there a way to find out the compiled-in port number?

Two ways, with Postgres running:
- Scan the server's ports with nmap.
- as root on the server, run "lsof | less" and look at the
Postgres process(es).

Both are fast, so do both. If lsof shows the PostgreSQL port but nmap
doesn't, then you'll know its being blocked by a firewall.

Martin

On 03/13/2012 02:16 AM, Виктор Егоров wrote:

Greetings.

Is there a way to find out the compiled-in port number?

I can parse `pg_config` output to check out port in cases port was
actually specified.

However if defaults had been used, is there any tool that will tell me
the magic 5432 number
or should I silently stick to this number in my scripts?

Not sure if this is what you want?:

This from Postgres 9.0.7.

test=> SELECT current_setting('port');
current_setting
-----------------
5432

test=> SELECT inet_server_port();
inet_server_port
------------------
5432

Be aware for inet_server_port() to work you have to connect in a method
other than Unix local socket. In other words something like:

psql -d test -U aklaver -h localhost

More information here:

http://www.postgresql.org/docs/9.0/interactive/functions-info.html

http://www.postgresql.org/docs/9.0/interactive/functions-admin.html

Thanks in advance!

--
Victor Y. Yegorov

--
Adrian Klaver
adrian.klaver@gmail.com