| From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Permanent settings |
| Date: | 2008-02-21 16:51:14 |
| Message-ID: | 47BDAC02.5040600@sun.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Mayer | 2008-02-21 16:53:19 | Re: Permanent settings |
| Previous Message | Hiroshi Saito | 2008-02-21 16:08:06 | OSSP can be used in the windows environment now! |