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

2010-04-13 Thread Rob Sargent
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)

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

2010-04-13 Thread IƱigo Martinez Lasala
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: pgsql-ad...@postgresql.org Subject: [ADMIN] Getting the initdb parameter values Date: Tue, 13 Apr 2010 17:

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

2010-04-13 Thread Satish Burnwal (sburnwal)
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 ?