Getting the initdb parameter values

Getting the initdb parameter values

am 13.04.2010 13:50:10 von sburnwal

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
?

=20

=20


------_=_NextPart_001_01CADAFF.78C7E8DC
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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


charset=3Dus-ascii">









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 ‘shared_buffers’ parameter is
determined during initdb. Is there any pg_* table which I look into for =
such params
?



 



 









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

Re: Getting the initdb parameter values

am 13.04.2010 15:54:50 von Kevin Grittner

"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 ?

> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Getting the initdb parameter values

am 13.04.2010 19:13:58 von Greg Smith

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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Getting the initdb parameter values

am 13.04.2010 20:01:35 von Julio Leyva

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






su - postgres
 =3Bpsql dbname -c "show all"

>=3B Date: Tue=
=2C 13 Apr 2010 13:13:58 -0400
>=3B From: greg@2ndquadrant.com
>=
=3B To: sburnwal@cisco.com
>=3B CC: pgsql-admin@postgresql.org
>=
=3B Subject: Re: [ADMIN] Getting the initdb parameter values
>=3B
=
>=3B Satish Burnwal (sburnwal) wrote:
>=3B >=3B
>=3B >=3B I=
have an existing postgres database and I want to know what are the
>=
=3B >=3B values of the parameters that were determined during initdb. Is =
there
>=3B >=3B any way to know those values ?
>=3B >=3B
=
>=3B
>=3B I normally use:
>=3B
>=3B select name=2Ccurren=
t_setting(name) from pg_settings where
>=3B source=3D'configuration f=
ile'
>=3B
>=3B To figure out all the things that were set at ini=
tdb time from a new
>=3B running database. You can also look at the =
postgresql.conf file it
>=3B generated and search for lines that are =
not commented out with "#" at
>=3B the start.
>=3B
>=3B --=

>=3B Greg Smith 2ndQuadrant US Baltimore=2C MD
>=3B PostgreSQ=
L Training=2C Services and Support
>=3B greg@2ndQuadrant.com www.2nd=
Quadrant.us
>=3B
>=3B
>=3B --
>=3B Sent via pgsql-ad=
min mailing list (pgsql-admin@postgresql.org)
>=3B To make changes to =
your subscription:
>=3B http://www.postgresql.org/mailpref/pgsql-admin=


=

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