From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
cc: "Sofer, Yuval" <Yuval_Sofer@bmc.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: set archive mode => on
In-reply-to: 
 <CA+U5nMJtFLaZq9K1zOLQx9E9P3xZUmN2pszRbr4wy7d80tgSVA@mail.gmail.com>
References: <05d9187d37584aee9847d1bcb01cdb81@phx-exmbprd-02.adprod.bmc.com>
 <CA+U5nMJtFLaZq9K1zOLQx9E9P3xZUmN2pszRbr4wy7d80tgSVA@mail.gmail.com>
Comments: In-reply-to Simon Riggs <simon@2ndquadrant.com>
 message dated "Mon, 04 Aug 2014 15:21:36 +0100"
Date: Mon, 04 Aug 2014 08:44:52 -0600
Message-ID: <744.1407163492@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin