Re: Getting the initdb parameter values - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Getting the initdb parameter values
Date
Msg-id 4BC4315A02000025000307C9@gw.wicourts.gov
Whole thread Raw
In response to Getting the initdb parameter values  ("Satish Burnwal (sburnwal)" <sburnwal@cisco.com>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: Dennis Thrysøe
Date:
Subject: Re: "the database system is starting up"
Next
From: Greg Smith
Date:
Subject: Re: Getting the initdb parameter values