| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(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 15:59:17 |
| Message-ID: | 47BD9FD5.4040307@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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=#
Joshua D. Drake
>
> Zdenek
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Saito | 2008-02-21 16:08:06 | OSSP can be used in the windows environment now! |
| Previous Message | Zdenek Kotala | 2008-02-21 15:57:53 | Re: Permanent settings |