From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
---|---|
To: | Birta Levente <blevi(dot)linux(at)gmail(dot)com> |
Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: archive_timeout runtime change |
Date: | 2011-10-22 22:20:34 |
Message-ID: | CALnrrJR66DwFPGL55mzaX38swfsVRGhJCbpL6ix=1POrzs69PA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2011/10/20 Birta Levente <blevi(dot)linux(at)gmail(dot)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.
>
>
postgres=# select name,setting,context from pg_settings where name like
'%archive%';
name | setting |
context
---------------------------+----------------------------------------------+------------
archive_timeout | 0 |
sighup
You have to edit the configuration file and then reload the Database server
to affect these changes. You can't change the "archive_timeout" value
without editing the PostgreSQL.conf file.
Below link describes,changing the postgresql.conf from a script:
http://blog.endpoint.com/2011/08/changing-postgresqlconf-from-script.html
--Raghu
From | Date | Subject | |
---|---|---|---|
Next Message | AI Rumman | 2011-10-23 03:31:09 | MVCC feature of postgresql |
Previous Message | raghu ram | 2011-10-22 21:49:55 | Re: Temporally disabled foreign key constraint check? |