Обсуждение: Runtime config of PGSQL

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

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

 

 

Re: Runtime config of PGSQL

От
Tom Lane
Дата:
"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