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

From Julio Leyva
Subject Re: Getting the initdb parameter values
Date
Msg-id BLU102-W22C93DD8DBB37F97BC117FA1110@phx.gbl
Whole thread Raw
In response to Re: Getting the initdb parameter values  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-admin
su - postgres
 psql dbname -c "show all"

> Date: Tue, 13 Apr 2010 13:13:58 -0400
> From: greg@2ndquadrant.com
> To: sburnwal@cisco.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Getting the initdb parameter values
>
> 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
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Greg Smith
Date:
Subject: Re: Getting the initdb parameter values
Next
From: Lewis Kapell
Date:
Subject: TOAST behavior in 8.3 and 8.4