su - postgres psql dbname -c "show all"
> Date: Tue, 13 Apr 2010 13:13:58 -0400 > From: g...@2ndquadrant.com > To: sburn...@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 > g...@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
