Thread: Re: [ADMIN] Getting the initdb parameter values

Re: [ADMIN] Getting the initdb parameter values

From
Iñigo Martinez Lasala
Date:
show shared_buffers;<br /><br /> or <br /><br /> show all; (for all parameters)<br /><br /> You can also check for
postgresql.conffile in your database folder.<br /><br /> -----Original Message-----<br /><b>From</b>: Satish Burnwal
(sburnwal)<<a
href="mailto:%22Satish%20Burnwal%20%28sburnwal%29%22%20%3csburnwal@cisco.com%3e">sburnwal@cisco.com</a>><br
/><b>To</b>:<a href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a><br /><b>Subject</b>: [ADMIN]
Gettingthe initdb parameter values<br /><b>Date</b>: Tue, 13 Apr 2010 17:20:10 +0530<br /><br /> I have an existing
postgresdatabase and I want to know what are the values of the parameters that were determined during initdb. Is there
anyway to know those values ? For example, doc
http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.htmlsays 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
?</tt><br/><br /><tt> </tt><br /><br />  <br /><br /><br /><br /> 

Re: [ADMIN] Getting the initdb parameter values

From
"Satish Burnwal (sburnwal)"
Date:
<div class="Section1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue">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
?</span></div>

Re: [ADMIN] Getting the initdb parameter values

From
Rob Sargent
Date:
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 ?
>