Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AE67B633786 for ; Tue, 13 Apr 2010 14:14:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33325-08 for ; Tue, 13 Apr 2010 17:14:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id 08E3963337F for ; Tue, 13 Apr 2010 14:14:08 -0300 (ADT) Received: from [192.168.0.105] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis) id 0M6xID-1NESXq3h13-00wq3L; Tue, 13 Apr 2010 19:14:00 +0200 Message-ID: <4BC4A656.2050105@2ndquadrant.com> Date: Tue, 13 Apr 2010 13:13:58 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: "Satish Burnwal (sburnwal)" CC: pgsql-admin@postgresql.org Subject: Re: Getting the initdb parameter values References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com> In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX19JUOqJUn+Q3+1ZByg3cp0K3OTY9fePVjKPZG4 13dTdlnxouiBe0hmsY5igH5DNocydWYl+5+zlEiE2egzQ9r+04 Pda13Ovg92ymYnNDG4qQJaIsxBx7ot/ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/163 X-Sequence-Number: 34257 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