Thread: How to find compiled-in default port number?
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?
--
Victor Y. Yegorov
Thanks in advance!
Victor Y. Yegorov
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