Re: Configure Different Databases on One Server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Configure Different Databases on One Server
Дата
Msg-id 16432.1446152714@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Configure Different Databases on One Server  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 10/29/2015 01:35 PM, Jim Longwill wrote:
>> ... I'm always getting this error:
>> ERROR:  parameter "autovacuum" cannot be changed now

>      Controls whether the server should run the autovacuum launcher
> daemon. This is on by default; however, track_counts must also be
> enabled for autovacuum to work. SEE--> This parameter can only be set in
> the postgresql.conf file or on the server command line. <---SEE

Yeah, this is more or less what I feared Jim would run into, though
I'd forgotten the details.  "autovacuum" actually controls whether the
launcher is started at all, and so it cannot be set on a per-database
basis.

I believe it might work to adjust many of the other autovac parameters
at the per-database level, but not that one.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Configure Different Databases on One Server
Следующее
От: Jim Longwill
Дата:
Сообщение: Re: Configure Different Databases on One Server