On Aug 4, 2014, at 9:46 AM, Sofer, Yuval <Yuval_Sofer(at)bmc(dot)com> wrote:
> Hi
> Is there any way to turn archive mode to on, without restarting Postgres database server?
handy query to show the context of the parameter. postmaster context requires a restart, sighup a reset works:
select name, setting, context from pg_settings;
chpt 18 is good, too.
http://www.postgresql.org/docs/9.3/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING