From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Sofer, Yuval <Yuval_Sofer@bmc.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: set archive mode => on
Date: Mon, 04 Aug 2014 08:44:52 -0600
Message-ID: <744.1407163492@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+U5nMJtFLaZq9K1zOLQx9E9P3xZUmN2pszRbr4wy7d80tgSVA@mail.gmail.com>
References: <05d9187d37584aee9847d1bcb01cdb81@phx-exmbprd-02.adprod.bmc.com>
<CA+U5nMJtFLaZq9K1zOLQx9E9P3xZUmN2pszRbr4wy7d80tgSVA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, simon@2ndquadrant.com, Yuval_Sofer@bmc.com
Subject: Re: set archive mode => on
In-Reply-To: <744.1407163492@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox