Re: [ADMIN] Getting the initdb parameter values

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(at)cisco(dot)com>
To: pgsql-admin(at)postgresql(dot)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 ?