archive_timeout runtime change
От
Birta Levente
Тема
archive_timeout runtime change
Дата
Msg-id
4E9FDE33.40403@gmail.com
Список
Дерево обсуждения
archive_timeout runtime change Birta Levente <blevi.linux@gmail.com>
Re: archive_timeout runtime change raghu ram <raghuchennuru@gmail.com>
Hi I use postgrsql 9.1.1 and I want to change archive_timeout on a running server. My default archive_timeout is 1800s, and nightly I want to change to 3600s or more, but I get the following error message: set archive_timeout='3600'; ERROR: parameter "archive_timeout" cannot be changed now and update pg_settings set setting='900' where name='archive_timeout'; ERROR: parameter "archive_timeout" cannot be changed now I know is possible to change this parameter with pg_ctl reload, but I think if is possible without changing the conf file. Thanks Levi
В списке pgsql-general по дате отправления