Re: Getting the initdb parameter values

"Satish Burnwal (sburnwal)" <sburnwal@cisco.com> 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://www.postgresql.org/docs/8.1/interactive/view-pg-settings.html

You could also look in the postgresql.conf file or use the SHOW
command.

http://www.postgresql.org/docs/8.1/interactive/runtime-config-file-locations.html

http://www.postgresql.org/docs/8.1/interactive/sql-show.html

-Kevin