Re: Permanent settings - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: Permanent settings
Date
Msg-id 47BDAC02.5040600@sun.com
Whole thread Raw
In response to Re: Permanent settings  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Joshua D. Drake napsal(a):
> Zdenek Kotala wrote:
> 
>> I like this idea. By my opinion only GUC variable with PGC_POSTMASTER 
>> context must be in postgresql.conf. Most of them are related to memory 
>> and networking configuration. Other can be only store in database. And 
>> for startup, default value will work pretty well.
>>
>> By the way, why postgresql.conf is required for startup when I'm able 
>> setup all parameter on command line?
>>
> 
> You aren't able to.
> 
> postgres=# set shared_buffers = '32768';
> ERROR:  parameter "shared_buffers" cannot be changed after server start
> STATEMENT:  set shared_buffers = '32768';
> ERROR:  parameter "shared_buffers" cannot be changed after server start
> postgres=#

I meant following notation:

/usr/bin/postgres -shared_buffers=32768
    Zdenek


pgsql-hackers by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: OSSP can be used in the windows environment now!
Next
From: Ron Mayer
Date:
Subject: Re: Permanent settings