| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Satish Burnwal (sburnwal)" <sburnwal(at)cisco(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Getting the initdb parameter values |
| Date: | 2010-04-13 13:54:50 |
| Message-ID: | 4BC4315A02000025000307C9@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
"Satish Burnwal (sburnwal)" <sburnwal(at)cisco(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tv | 2010-04-13 14:25:59 | Re: [ADMIN] Query is stuck |
| Previous Message | Satish Burnwal (sburnwal) | 2010-04-13 13:51:19 | Re: [ADMIN] Query is stuck |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-04-13 17:13:58 | Re: Getting the initdb parameter values |
| Previous Message | Satish Burnwal (sburnwal) | 2010-04-13 13:01:06 | Re: [ADMIN] Getting the initdb parameter values |