Re: [ADMIN] Getting the initdb parameter values
От | Iñigo Martinez Lasala |
---|---|
Тема | Re: [ADMIN] Getting the initdb parameter values |
Дата | |
Msg-id | 1271163390.2285.84.camel@deimos обсуждение исходный текст |
Ответы |
Re: [ADMIN] Getting the initdb parameter values
|
Список | pgsql-sql |
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 />
В списке pgsql-sql по дате отправления: