From: Greg Smith <greg@2ndquadrant.com>
To: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Getting the initdb parameter values
Date: Tue, 13 Apr 2010 13:13:58 -0400
Message-ID: <4BC4A656.2050105@2ndquadrant.com> (raw)
In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
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@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: greg@2ndquadrant.com, sburnwal@cisco.com, pgsql-admin@postgresql.org
Subject: Re: Getting the initdb parameter values
In-Reply-To: <4BC4A656.2050105@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox