Re: [SQL] [ADMIN] Getting the initdb parameter values
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 ?
Re: [SQL] [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) To: [email protected] 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 ?
Re: [SQL] [ADMIN] Getting the initdb parameter values
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 ? > -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
