pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedGetting the initdb parameter values
7+ messages / 6 participants
[nested] [flat]
* Getting the initdb parameter values
@ 2010-04-13 11:50 Satish Burnwal (sburnwal) <sburnwal@cisco.com>
0 siblings, 3 replies; 7+ messages in thread
From: Satish Burnwal (sburnwal) @ 2010-04-13 11:50 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
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
?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] Getting the initdb parameter values
@ 2010-04-13 12:56 Iñigo Martinez Lasala <imartinez@vectorsf.com>
parent: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
2 siblings, 1 reply; 7+ messages in thread
From: Iñigo Martinez Lasala @ 2010-04-13 12:56 UTC (permalink / raw)
To: Satish Burnwal (sburnwal) <sburnwal@cisco.com>; +Cc: pgsql-sql
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 ?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] Getting the initdb parameter values
@ 2010-04-13 13:01 Satish Burnwal (sburnwal) <sburnwal@cisco.com>
parent: Iñigo Martinez Lasala <imartinez@vectorsf.com>
0 siblings, 1 reply; 7+ messages in thread
From: Satish Burnwal (sburnwal) @ 2010-04-13 13:01 UTC (permalink / raw)
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>; +Cc: pgsql-sql
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 ?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Getting the initdb parameter values
@ 2010-04-13 13:54 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
2 siblings, 0 replies; 7+ messages in thread
From: Kevin Grittner @ 2010-04-13 13:54 UTC (permalink / raw)
To: Satish Burnwal (sburnwal) <sburnwal@cisco.com>; pgsql-admin@postgresql.org
"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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Getting the initdb parameter values
@ 2010-04-13 17:13 Greg Smith <greg@2ndquadrant.com>
parent: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
2 siblings, 1 reply; 7+ messages in thread
From: Greg Smith @ 2010-04-13 17:13 UTC (permalink / raw)
To: Satish Burnwal (sburnwal) <sburnwal@cisco.com>; +Cc: pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] Getting the initdb parameter values
@ 2010-04-13 17:57 Rob Sargent <robjsargent@gmail.com>
parent: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
0 siblings, 0 replies; 7+ messages in thread
From: Rob Sargent @ 2010-04-13 17:57 UTC (permalink / raw)
To: pgsql-sql
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 ?
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Getting the initdb parameter values
@ 2010-04-13 18:01 Julio Leyva <jcleyva@hotmail.com>
parent: Greg Smith <greg@2ndquadrant.com>
0 siblings, 0 replies; 7+ messages in thread
From: Julio Leyva @ 2010-04-13 18:01 UTC (permalink / raw)
To: greg@2ndquadrant.com; sburnwal@cisco.com; +Cc: pgsql-admin@postgresql.org
su - postgres
psql dbname -c "show all"
> Date: Tue, 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
>
> 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
=
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2010-04-13 18:01 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-13 11:50 Getting the initdb parameter values Satish Burnwal (sburnwal) <sburnwal@cisco.com>
2010-04-13 12:56 ` Iñigo Martinez Lasala <imartinez@vectorsf.com>
2010-04-13 13:01 ` Satish Burnwal (sburnwal) <sburnwal@cisco.com>
2010-04-13 17:57 ` Rob Sargent <robjsargent@gmail.com>
2010-04-13 13:54 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-13 17:13 ` Greg Smith <greg@2ndquadrant.com>
2010-04-13 18:01 ` Julio Leyva <jcleyva@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox