Runtime config of PGSQL

Поиск
Список
Период
Сортировка
Искать

Runtime config of PGSQL

От:
"Akshay Mathur" <akshay.mathur@wibhu.com>
Дата:

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

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Akshay Mathur"  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
FAQ