From sburnwal@cisco.com Tue Apr  13 12:00:21 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 80E4E633988
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <pgsql-admin@postgresql.org>; 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)" <sburnwal@cisco.com>
To: <pgsql-admin@postgresql.org>
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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
	{mso-style-priority:99;
	mso-style-link:"Plain Text Char";
	margin:0in;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Verdana","sans-serif";
	color:blue;}
tt
	{mso-style-priority:99;
	font-family:"Courier New";}
span.EmailStyle17
	{mso-style-type:personal;
	font-family:"Verdana","sans-serif";
	color:blue;}
span.PlainTextChar
	{mso-style-name:"Plain Text Char";
	mso-style-priority:99;
	mso-style-link:"Plain Text";
	font-family:"Verdana","sans-serif";
	color:blue;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoPlainText>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 &#8216;<tt>shared_buffers&#8217; parameter is
determined during initdb. Is there any pg_* table which I look into for =
such params
?<o:p></o:p></tt></p>

<p class=3DMsoPlainText><tt><o:p>&nbsp;</o:p></tt></p>

<p class=3DMsoPlainText><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>

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



From imartinez@vectorsf.com Tue Apr  13 12:56:51 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 16531632315
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 09:56:51 -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 80240-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 12:56:37 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id 26F116322D1
	for <pgsql-sql@postgresql.org>; Tue, 13 Apr 2010 09:56:38 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id 14EE211C0047;
	Tue, 13 Apr 2010 14:55:50 +0200 (CEST)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id ENe1KPj3UHOI; Tue, 13 Apr 2010 14:55:45 +0200 (CEST)
Received: from [10.70.4.200] (unknown [10.70.4.200])
	(Authenticated sender: imartinez)
	by hermes.vectorsf.com (Postfix) with ESMTP id 7919011C0046;
	Tue, 13 Apr 2010 14:55:45 +0200 (CEST)
Subject: Re: [ADMIN] Getting the initdb parameter values
From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
To: "Satish Burnwal (sburnwal)" <sburnwal@cisco.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
Content-Type: multipart/alternative; boundary="=-CjF4LVTU+ke7jbyk2ugb"
Date: Tue, 13 Apr 2010 14:56:30 +0200
Message-ID: <1271163390.2285.84.camel@deimos>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.3 
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/47
X-Sequence-Number: 33974


--=-CjF4LVTU+ke7jbyk2ugb
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit

show shared_buffers;

or 

show all; (for all parameters)

You can also check for postgresql.conf file in your database folder.

-----Original Message-----
From: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Getting the initdb parameter values
Date: Tue, 13 Apr 2010 17:20:10 +0530

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.html 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 ?

 

 




--=-CjF4LVTU+ke7jbyk2ugb
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.28.3">
</HEAD>
<BODY LINK="#0000ff">
show shared_buffers;<BR>
<BR>
or <BR>
<BR>
show all; (for all parameters)<BR>
<BR>
You can also check for postgresql.conf file in your database folder.<BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: Satish Burnwal (sburnwal) &lt;<A HREF="mailto:%22Satish%20Burnwal%20%28sburnwal%29%22%20%3csburnwal@cisco.com%3e">sburnwal@cisco.com</A>&gt;<BR>
<B>To</B>: <A HREF="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</A><BR>
<B>Subject</B>: [ADMIN] Getting the initdb parameter values<BR>
<B>Date</B>: Tue, 13 Apr 2010 17:20:10 +0530<BR>
<BR>
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.html says that the max value of &#8216;<TT>shared_buffers&#8217; parameter is determined during initdb. Is there any pg_* table which I look into for such params ?</TT><BR>
<BR>
<TT>&nbsp;</TT><BR>
<BR>
&nbsp;<BR>
<BR>
<BR>
<BR>
</BODY>
</HTML>

--=-CjF4LVTU+ke7jbyk2ugb--




From sburnwal@cisco.com Tue Apr  13 13:01:23 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id AC64A6322D1
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 10:01:23 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 67160-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 13:01:04 +0000 (UTC)
X-Greylist: from auto-whitelisted 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 A36DE633934
	for <pgsql-sql@postgresql.org>; Tue, 13 Apr 2010 10:01:12 -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: 
 AlkFAGUIxEtAaHte/2dsb2JhbACBP4FVl19VcaF4iFGROYQfbgSDJQ
X-IronPort-AV: E=Sophos;i="4.52,197,1270425600";
	d="scan'208,217";a="114473901"
Received: from hkg-core-1.cisco.com ([64.104.123.94])
	by sj-iport-4.cisco.com with ESMTP; 13 Apr 2010 13:01:10 +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 o3DD19eq008459;
	Tue, 13 Apr 2010 13:01:09 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 18:31:09 +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_01CADB09.6282DFBE"
Subject: Re: [ADMIN] Getting the initdb parameter values
Date: Tue, 13 Apr 2010 18:31:06 +0530
Message-ID: <3A8C969225424C4D8E6BEE65ED8552DA0119F18A@XMB-BGL-41C.cisco.com>
In-Reply-To: <1271163390.2285.84.camel@deimos>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [ADMIN] Getting the initdb parameter values
Thread-Index: AcrbCMeB/5at5arRQwSoKSFCzhydNQAAE7VQ
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
	<1271163390.2285.84.camel@deimos>
From: "Satish Burnwal (sburnwal)" <sburnwal@cisco.com>
To: =?utf-8?B?ScOxaWdvIE1hcnRpbmV6IExhc2FsYQ==?= <imartinez@vectorsf.com>
Cc: "pgsql-sql" <pgsql-sql@postgresql.org>
X-OriginalArrivalTime: 13 Apr 2010 13:01:09.0093 (UTC)
	FILETIME=[62B88950:01CADB09]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.285 tagged_above=-10 required=5 tests=AWL=-0.275,
	BAYES_20=-0.001, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201004/48
X-Sequence-Number: 33975

This is a multi-part message in MIME format.

------_=_NextPart_001_01CADB09.6282DFBE
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: base64

V2hhdCB5b3UgaGF2ZSBtZW50aW9uZWQgaXMgYWxyZWFkeSB0aGVyZSBpbiBwb3N0Z3Jlc3FsLmNv
bmYgZmlsZS4gSSB3YW50IHRvIGtub3cgd2hhdHMgdGhlIG1heCB2YWx1ZSBhbGxvd2VkID8gRG9j
IHNlZW1zIHRvIGJlIHNheWluZyB0aGF0IG1heCBhbGxvd2VkIHZhbHVlIGlzIGRldGVybWluZWQg
ZHVyaW5nIGluaXRkYi4gSG93IHRvIGdldCB0aGlzIG1heCBhbGxvd2VkIHZhbHVlID8NCg0K

------_=_NextPart_001_01CADB09.6282DFBE
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: base64

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+DQoNCjxoZWFkPg0KPG1ldGEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUg
Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9R2VuZXJhdG9y
IGNvbnRlbnQ9Ik1pY3Jvc29mdCBXb3JkIDEyIChmaWx0ZXJlZCBtZWRpdW0pIj4NCjxzdHlsZT4N
CjwhLS0NCiAvKiBGb250IERlZmluaXRpb25zICovDQogQGZvbnQtZmFjZQ0KCXtmb250LWZhbWls
eToiQ2FtYnJpYSBNYXRoIjsNCglwYW5vc2UtMToyIDQgNSAzIDUgNCA2IDMgMiA0O30NCkBmb250
LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q2FsaWJyaTsNCglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAz
IDIgNDt9DQpAZm9udC1mYWNlDQoJe2ZvbnQtZmFtaWx5OlZlcmRhbmE7DQoJcGFub3NlLTE6MiAx
MSA2IDQgMyA1IDQgNCAyIDQ7fQ0KIC8qIFN0eWxlIERlZmluaXRpb25zICovDQogcC5Nc29Ob3Jt
YWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1i
b3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTIuMHB0Ow0KCWZvbnQtZmFtaWx5OiJUaW1lcyBO
ZXcgUm9tYW4iLCJzZXJpZiI7fQ0KYTpsaW5rLCBzcGFuLk1zb0h5cGVybGluaw0KCXttc28tc3R5
bGUtcHJpb3JpdHk6OTk7DQoJY29sb3I6Ymx1ZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5l
O30NCmE6dmlzaXRlZCwgc3Bhbi5Nc29IeXBlcmxpbmtGb2xsb3dlZA0KCXttc28tc3R5bGUtcHJp
b3JpdHk6OTk7DQoJY29sb3I6cHVycGxlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0K
dHQNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWZvbnQtZmFtaWx5OiJDb3VyaWVyIE5ldyI7
fQ0Kc3Bhbi5FbWFpbFN0eWxlMTgNCgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtcmVwbHk7DQoJ
Zm9udC1mYW1pbHk6IlZlcmRhbmEiLCJzYW5zLXNlcmlmIjsNCgljb2xvcjpibHVlO30NCi5Nc29D
aHBEZWZhdWx0DQoJe21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtc2l6ZToxMC4w
cHQ7fQ0KQHBhZ2UgU2VjdGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47DQoJbWFyZ2luOjEuMGlu
IDEuMGluIDEuMGluIDEuMGluO30NCmRpdi5TZWN0aW9uMQ0KCXtwYWdlOlNlY3Rpb24xO30NCi0t
Pg0KPC9zdHlsZT4NCjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KIDxvOnNoYXBlZGVmYXVsdHMg
djpleHQ9ImVkaXQiIHNwaWRtYXg9IjEwMjYiIC8+DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lm
IGd0ZSBtc28gOV0+PHhtbD4NCiA8bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+DQogIDxvOmlk
bWFwIHY6ZXh0PSJlZGl0IiBkYXRhPSIxIiAvPg0KIDwvbzpzaGFwZWxheW91dD48L3htbD48IVtl
bmRpZl0tLT4NCjwvaGVhZD4NCg0KPGJvZHkgbGFuZz1FTi1VUyBsaW5rPWJsdWUgdmxpbms9cHVy
cGxlPg0KDQo8ZGl2IGNsYXNzPVNlY3Rpb24xPg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4g
c3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7Zm9udC1mYW1pbHk6IlZlcmRhbmEiLCJzYW5zLXNlcmlm
IjsNCmNvbG9yOmJsdWUnPldoYXQgeW91IGhhdmUgbWVudGlvbmVkIGlzIGFscmVhZHkgdGhlcmUg
aW4gcG9zdGdyZXNxbC5jb25mIGZpbGUuIEkNCndhbnQgdG8ga25vdyB3aGF0cyB0aGUgbWF4IHZh
bHVlIGFsbG93ZWQgPyBEb2Mgc2VlbXMgdG8gYmUgc2F5aW5nIHRoYXQgbWF4DQphbGxvd2VkIHZh
bHVlIGlzIGRldGVybWluZWQgZHVyaW5nIGluaXRkYi4gSG93IHRvIGdldCB0aGlzIG1heCBhbGxv
d2VkIHZhbHVlID88L3NwYW4+PG86cD48L286cD48L3A+DQoNCjwvZGl2Pg0KDQo8L2JvZHk+DQoN
CjwvaHRtbD4NCg==

------_=_NextPart_001_01CADB09.6282DFBE--



From Kevin.Grittner@wicourts.gov Tue Apr  13 13:55:13 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id CBEE9633BB4
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 10:55:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 76897-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 13:54:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by mail.postgresql.org (Postfix) with ESMTP id CA02163557B
	for <pgsql-admin@postgresql.org>; Tue, 13 Apr 2010 10:54:58 -0300 (ADT)
Received: from Courts-MTA by gw.wicourts.gov
	with Novell_GroupWise; Tue, 13 Apr 2010 08:54:57 -0500
Message-Id: <4BC4315A02000025000307C9@gw.wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 8.0.1 
Date: Tue, 13 Apr 2010 08:54:50 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Satish Burnwal (sburnwal)" <sburnwal@cisco.com>,
	<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>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.078 tagged_above=-10 required=5 tests=AWL=-0.168,
	BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201004/162
X-Sequence-Number: 34256

"Satish Burnwal (sburnwal)" <sburnwal@cisco.com> 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 ?
 
> Is there any pg_* table which I look into for such params?
 
There is:
 
http://www.postgresql.org/docs/8.1/interactive/view-pg-settings.html
 
You could also look in the postgresql.conf file or use the SHOW
command.
 
http://www.postgresql.org/docs/8.1/interactive/runtime-config-file-locations.html
 
http://www.postgresql.org/docs/8.1/interactive/sql-show.html
 
-Kevin



From greg@2ndquadrant.com Tue Apr  13 17:14:18 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id AE67B633786
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: "Satish Burnwal (sburnwal)" <sburnwal@cisco.com>
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




From robjsargent@gmail.com Tue Apr  13 17:56:46 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D6B6B635885
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 14:56:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 23202-01-4 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 17:56:33 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id 72F19635861
	for <pgsql-sql@postgresql.org>; Tue, 13 Apr 2010 14:56:34 -0300 (ADT)
Received: from in01.mta.xmission.com ([166.70.13.51])
	by out01.mta.xmission.com with esmtps (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1O1kLg-0008VI-VS; Tue, 13 Apr 2010 11:56:32 -0600
Received: from [208.187.158.94] (helo=[172.16.1.233])
	by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1O1kLg-0000TN-Pw; Tue, 13 Apr 2010 11:56:32 -0600
Message-ID: <4BC4B0A1.2090604@gmail.com>
Date: Tue, 13 Apr 2010 11:57:53 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.8) Gecko/20100228 SUSE/3.0.3-1.1.1 Thunderbird/3.0.3
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: [ADMIN] Getting the initdb parameter values
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
	<1271163390.2285.84.camel@deimos>
	<3A8C969225424C4D8E6BEE65ED8552DA0119F18A@XMB-BGL-41C.cisco.com>
In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F18A@XMB-BGL-41C.cisco.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: pgsql-sql@postgresql.org, rsargent@amirsys.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-SA-Exim-Scanned: No (on in01.mta.xmission.com);
	SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.947 tagged_above=-10 required=5 tests=AWL=-0.047,
	BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201004/49
X-Sequence-Number: 33976

As I read it, it doesn't matter what the value was originally, it's
what's in postgresql.conf _now_ that matters.

This is a resource allocation: I suspect there's no limit on how much of
your (often precious) memory you wish to set aside for this.

On 04/13/2010 07:01 AM, Satish Burnwal (sburnwal) wrote:
> What you have mentioned is already there in postgresql.conf file. I want
> to know whats the max value allowed ? Doc seems to be saying that max
> allowed value is determined during initdb. How to get this max allowed
> value ?
> 



From jcleyva@hotmail.com Tue Apr  13 18:01:49 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id A819E633786
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 15:01:49 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 24272-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Apr 2010 18:01:36 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from blu0-omc2-s10.blu0.hotmail.com (blu0-omc2-s10.blu0.hotmail.com
	[65.55.111.85])
	by mail.postgresql.org (Postfix) with ESMTP id ABCC463333A
	for <pgsql-admin@postgresql.org>; Tue, 13 Apr 2010 15:01:38 -0300 (ADT)
Received: from BLU102-W22 ([65.55.111.71]) by blu0-omc2-s10.blu0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Tue, 13 Apr 2010 11:01:36 -0700
Message-ID: <BLU102-W22C93DD8DBB37F97BC117FA1110@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_d8a8a4d4-6d67-42b2-9f0e-ca81ac91a9ce_"
X-Originating-IP: [207.164.182.8]
From: Julio Leyva <jcleyva@hotmail.com>
To: <greg@2ndquadrant.com>, <sburnwal@cisco.com>
CC: <pgsql-admin@postgresql.org>
Subject: Re: Getting the initdb parameter values
Date: Tue, 13 Apr 2010 18:01:35 +0000
Importance: Normal
In-Reply-To: <4BC4A656.2050105@2ndquadrant.com>
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>,
	<4BC4A656.2050105@2ndquadrant.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 13 Apr 2010 18:01:36.0168 (UTC)
	FILETIME=[5BB1E280:01CADB33]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.163 tagged_above=-10 required=5 tests=AWL=0.746,
	BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201004/164
X-Sequence-Number: 34258

--_d8a8a4d4-6d67-42b2-9f0e-ca81ac91a9ce_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


su - postgres
 psql dbname -c "show all"

> Date: Tue=2C 13 Apr 2010 13:13:58 -0400
> From: greg@2ndquadrant.com
> To: sburnwal@cisco.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Getting the initdb parameter values
>=20
> Satish Burnwal (sburnwal) wrote:
> >
> > I have an existing postgres database and I want to know what are the=20
> > values of the parameters that were determined during initdb. Is there=20
> > any way to know those values ?
> >
>=20
> I normally use:
>=20
> select name=2Ccurrent_setting(name) from pg_settings where=20
> source=3D'configuration file'
>=20
> To figure out all the things that were set at initdb time from a new=20
> running database.  You can also look at the postgresql.conf file it=20
> generated and search for lines that are not commented out with "#" at=20
> the start.
>=20
> --=20
> Greg Smith  2ndQuadrant US  Baltimore=2C MD
> PostgreSQL Training=2C Services and Support
> greg@2ndQuadrant.com   www.2ndQuadrant.us
>=20
>=20
> --=20
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
 		 	   		  =

--_d8a8a4d4-6d67-42b2-9f0e-ca81ac91a9ce_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
su - postgres<br>&nbsp=3Bpsql dbname -c "show all"<br><br>&gt=3B Date: Tue=
=2C 13 Apr 2010 13:13:58 -0400<br>&gt=3B From: greg@2ndquadrant.com<br>&gt=
=3B To: sburnwal@cisco.com<br>&gt=3B CC: pgsql-admin@postgresql.org<br>&gt=
=3B Subject: Re: [ADMIN] Getting the initdb parameter values<br>&gt=3B <br>=
&gt=3B Satish Burnwal (sburnwal) wrote:<br>&gt=3B &gt=3B<br>&gt=3B &gt=3B I=
 have an existing postgres database and I want to know what are the <br>&gt=
=3B &gt=3B values of the parameters that were determined during initdb. Is =
there <br>&gt=3B &gt=3B any way to know those values ?<br>&gt=3B &gt=3B<br>=
&gt=3B <br>&gt=3B I normally use:<br>&gt=3B <br>&gt=3B select name=2Ccurren=
t_setting(name) from pg_settings where <br>&gt=3B source=3D'configuration f=
ile'<br>&gt=3B <br>&gt=3B To figure out all the things that were set at ini=
tdb time from a new <br>&gt=3B running database.  You can also look at the =
postgresql.conf file it <br>&gt=3B generated and search for lines that are =
not commented out with "#" at <br>&gt=3B the start.<br>&gt=3B <br>&gt=3B --=
 <br>&gt=3B Greg Smith  2ndQuadrant US  Baltimore=2C MD<br>&gt=3B PostgreSQ=
L Training=2C Services and Support<br>&gt=3B greg@2ndQuadrant.com   www.2nd=
Quadrant.us<br>&gt=3B <br>&gt=3B <br>&gt=3B -- <br>&gt=3B Sent via pgsql-ad=
min mailing list (pgsql-admin@postgresql.org)<br>&gt=3B To make changes to =
your subscription:<br>&gt=3B http://www.postgresql.org/mailpref/pgsql-admin=
<br> 		 	   		  </body>
</html>=

--_d8a8a4d4-6d67-42b2-9f0e-ca81ac91a9ce_--