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_--