Home > mailing lists

Re: set archive mode => on - Mailing list pgsql-admin

From	Ray Stell
Subject	Re: set archive mode => on
Date	August 4, 2014 17:38:27
Msg-id	8E52AB0F-2D29-4CEA-9842-9CCB324D468B@vt.edu Whole thread Raw
In response to	set archive mode => on ("Sofer, Yuval" <Yuval_Sofer@bmc.com>)
List	pgsql-admin

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.

From: Simon Riggs
Date: 04 August 2014, 17:22:03
Subject: Re: set archive mode => on

From: Tom Lane
Date: 04 August 2014, 17:44:58
Subject: Re: set archive mode => on