Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80E4E633988 for ; Tue, 13 Apr 2010 09:00:21 -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 06980-09 for ; Tue, 13 Apr 2010 12:00:10 +0000 (UTC) X-Greylist: delayed 00:09:38.420374 by SQLgrey-1.7.6 Received: from sj-iport-4.cisco.com (sj-iport-4.cisco.com [171.68.10.86]) by mail.postgresql.org (Postfix) with ESMTP id B78C563252A for ; Tue, 13 Apr 2010 08:59:53 -0300 (ADT) Authentication-Results: sj-iport-4.cisco.com; dkim=neutral (message not signed) header.i=none X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AskGANn2w0tAaHte/2dsb2JhbACBPo4pi19xoUuaAYUNBIMl X-IronPort-AV: E=Sophos;i="4.52,197,1270425600"; d="scan'208,217";a="114451675" Received: from hkg-core-1.cisco.com ([64.104.123.94]) by sj-iport-4.cisco.com with ESMTP; 13 Apr 2010 11:50:12 +0000 Received: from xbh-bgl-412.cisco.com (xbh-bgl-412.cisco.com [72.163.129.202]) by hkg-core-1.cisco.com (8.13.8/8.14.3) with ESMTP id o3DBoB1U020054 for ; Tue, 13 Apr 2010 11:50:11 GMT Received: from xmb-bgl-41c.cisco.com ([72.163.129.218]) by xbh-bgl-412.cisco.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 13 Apr 2010 17:20:11 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CADAFF.78C7E8DC" Subject: Getting the initdb parameter values Date: Tue, 13 Apr 2010 17:20:10 +0530 Message-ID: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Getting the initdb parameter values Thread-Index: Acra/3hNa2/ttR2jQ5Gb1UayoouFhw== From: "Satish Burnwal (sburnwal)" To: X-OriginalArrivalTime: 13 Apr 2010 11:50:11.0289 (UTC) FILETIME=[78DF3490:01CADAFF] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/149 X-Sequence-Number: 34243 This is a multi-part message in MIME format. ------_=_NextPart_001_01CADAFF.78C7E8DC Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 ? For example, doc http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.h tml says that the max value of 'shared_buffers' parameter is determined during initdb. Is there any pg_* table which I look into for such params ? =20 =20 ------_=_NextPart_001_01CADAFF.78C7E8DC Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 ? For example, doc http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.ht= ml says that the max value of ‘shared_buffers’ parameter is determined during initdb. Is there any pg_* table which I look into for = such params ?

------_=_NextPart_001_01CADAFF.78C7E8DC--