Getting the initdb parameter values

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-confi g-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
?






------_=_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 */
[at] font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] 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;}
[at] 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-confi g-resource.ht=
ml
says that the max value of ‘<tt>shared_buffers’ 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> </o:p></tt></p>

<p class=3DMsoPlainText><o:p> </o:p></p>

</div>

</body>

</html>

------_=_NextPart_001_01CADAFF.78C7E8DC--
sburnwal [ Di, 13 April 2010 13:50 ] [ ID #2038662 ]

Re: Getting the initdb parameter values

"Satish Burnwal (sburnwal)" <sburnwal [at] 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-setti ngs.html

You could also look in the postgresql.conf file or use the SHOW
command.

http://www.postgresql.org/docs/8.1/interactive/runtime-confi g-file-locations.html

http://www.postgresql.org/docs/8.1/interactive/sql-show.html

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Grittner [ Di, 13 April 2010 15:54 ] [ ID #2038675 ]

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 [at] 2ndQuadrant.com www.2ndQuadrant.us


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Greg Smith [ Di, 13 April 2010 19:13 ] [ ID #2038676 ]

Re: Getting the initdb parameter values

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

--_d8a8a4d4-6d67-42b2-9f0e-ca81ac91a9ce_--
Julio Leyva [ Di, 13 April 2010 20:01 ] [ ID #2038677 ]
Datenbanken » gmane.comp.db.postgresql.admin » Getting the initdb parameter values

Vorheriges Thema: TOAST behavior in 8.3 and 8.4
Nächstes Thema: "the database system is starting up"

[ Startseite ] [ Administrator ] [ Suche ] [ Hinweise ] [ Impressum ]

Powered by FudForum