Обсуждение: set archive mode => on
Hi
Is there any way to turn archive mode to on, without restarting Postgres database server?
Thanks,
Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team
972-52-4286-282
Le 4 août 2014 15:48, "Sofer, Yuval" <Yuval_Sofer@bmc.com> a écrit :
>
> Hi
>
> Is there any way to turn archive mode to on, without restarting Postgres database server?
>
No.
"Sofer, Yuval" <Yuval_Sofer@bmc.com> wrote: > Is there any way to turn archive mode to on, without restarting > Postgres database server? http://www.postgresql.org/docs/current/interactive/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING "This parameter can only be set at server start." -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On 4 August 2014 14:46, Sofer, Yuval <Yuval_Sofer@bmc.com> wrote: > Is there any way to turn archive mode to on, without restarting Postgres > database server? Sorry, not currently. But it is something we've wanted to add for some time. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
On Aug 4, 2014, at 9:46 AM, Sofer, Yuval <Yuval_Sofer@bmc.com> wrote:
HiIs 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.
Вложения
Simon Riggs <simon@2ndquadrant.com> writes: > On 4 August 2014 14:46, Sofer, Yuval <Yuval_Sofer@bmc.com> wrote: >> Is there any way to turn archive mode to on, without restarting Postgres >> database server? > Sorry, not currently. > But it is something we've wanted to add for some time. The existing compromise on this is that archive_command is separate from archive_mode, and archive_command *can* be changed on the fly. So you can run with archive_mode on and set archive_command to a no-op (I think an empty string might work, read the docs), if you think you might want to activate archiving later without restarting. regards, tom lane