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