From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [ADMIN] Getting the initdb parameter values
Date: Tue, 13 Apr 2010 14:56:30 +0200
Message-ID: <1271163390.2285.84.camel@deimos> (raw)
In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com>
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 ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: imartinez@vectorsf.com, sburnwal@cisco.com
Subject: Re: [ADMIN] Getting the initdb parameter values
In-Reply-To: <1271163390.2285.84.camel@deimos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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