archive_timeout runtime change

Birta Levente <blevi.linux@xxxxxxxxx> · Thu, 20 Oct 2011 11:39:15 +0300

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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general