Runtime config of PGSQL

[Akshay Mathur]

Hello!

Is there any way to see that a postmaster is running with what
configuration? I want to verify if it picked up all the values from
postgresql.conf or not. Also I want to know what values it has taken for
the parameters which are commented in my conf file.

Regards,

akshay
---------------------------------------
Akshay Mathur
Product Verification
Wibhu Technologies ( <http://www.wibhu.com> www.wibhu.com)

[Tom Lane]

Post by Akshay Mathur
Is there any way to see that a postmaster is running with what
configuration? I want to verify if it picked up all the values from
postgresql.conf or not. Also I want to know what values it has taken for
the parameters which are commented in my conf file.

SHOW ALL ... or SELECT * FROM pg_settings ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)