su - postgres psql dbname -c "show all"
> Date: Tue, 13 Apr 2010 13:13:58 -0400 > From: [email protected] > To: [email protected] > CC: [email protected] > 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 > [email protected] www.2ndQuadrant.us > > > -- > Sent via pgsql-admin mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin
