set archive mode => on
set archive mode => on
От:
"Sofer, Yuval" <Yuval_Sofer@bmc.com>
Дата:
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
Re: set archive mode => on
От:
Guillaume Lelarge <guillaume@lelarge.info>
Дата:
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.
Re: set archive mode => on
От:
Kevin Grittner <kgrittn@ymail.com>
Дата:
"Sofer, Yuval" 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
Re: set archive mode => on
От:
Simon Riggs <simon@2ndquadrant.com>
Дата:
On 4 August 2014 14:46, Sofer, Yuval 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
Re: set archive mode => on
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.
Re: set archive mode => on
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Simon Riggs writes: > On 4 August 2014 14:46, Sofer, Yuval 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