Re: Permanent settings
| От | Zdenek Kotala |
|---|---|
| Тема | Re: Permanent settings |
| Дата | |
| Msg-id | 47BDAC02.5040600@sun.com обсуждение исходный текст |
| Ответ на | Re: Permanent settings ("Joshua D. Drake" <jd@commandprompt.com>) |
| Список | 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 по дате отправления: