Postgres Pro
Downloads
Home   >   mailing lists

Thread: Runtime config of PGSQL

Runtime config of PGSQL

From
"Akshay Mathur"
Date:

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 (www.wibhu.com)

 

 

Re: Runtime config of PGSQL

From
Tom Lane
Date:
"Akshay Mathur" <akshay.mathur@wibhu.com> writes:
> 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