| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Satish Burnwal (sburnwal)" <sburnwal(at)cisco(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Getting the initdb parameter values |
| Date: | 2010-04-13 17:13:58 |
| Message-ID: | 4BC4A656.2050105@2ndquadrant.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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='configuration file'
To figure out all the things that were set at initdb time from a new
running database. You can also look at the postgresql.conf file it
generated and search for lines that are not commented out with "#" at
the start.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2010-04-13 17:57:53 | Re: [ADMIN] Getting the initdb parameter values |
| Previous Message | Jeffrey Gaynor | 2010-04-13 17:04:43 | SSL question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2010-04-13 17:57:53 | Re: [ADMIN] Getting the initdb parameter values |
| Previous Message | Kevin Grittner | 2010-04-13 13:54:50 | Re: Getting the initdb parameter values |