su - postgres
psql dbname -c "show all"
> Date: Tue, 13 Apr 2010 13:13:58 -0400
> From: g...@2ndquadrant.com
> To: sburn...@cisco.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Getting the initdb parameter values
>
> Satish Burnwal (sburnwal) wr
Satish Burnwal (sburnwal) wrote:
I have an existing postgres database and I want to know what are the
values of the parameters that were determined during initdb. Is there
any way to know those values ?
I normally use:
select name,current_setting(name) from pg_settings where
source='conf
"Satish Burnwal (sburnwal)" wrote:
> I have an existing postgres database and I want to know what are
> the values of the parameters that were determined during initdb.
> Is there any way to know those values ?
> Is there any pg_* table which I look into for such params?
There is:
http://w
I have an existing postgres database and I want to know what are the
values of the parameters that were determined during initdb. Is there
any way to know those values ? For example, doc
http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.h
tml says that the max value of 'shared_
