Обсуждение: set archive mode => on

Поиск
Список
Период
Сортировка

set archive mode => on

От
"Sofer, Yuval"
Дата:

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

yuval_sofer@bmc.com

 

 

 

 

Re: set archive mode => on

От
Guillaume Lelarge
Дата:

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
Дата:
"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

Re: set archive mode => on

От
Simon Riggs
Дата:
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

Re: set archive mode => on

От
Ray Stell
Дата:

On Aug 4, 2014, at 9:46 AM, Sofer, Yuval <Yuval_Sofer@bmc.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.  
Вложения

Re: set archive mode => on

От
Tom Lane
Дата:
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