From: Scott Mead <scott.lists@enterprisedb.com>
To: John Lister <john.lister-ps@kickstone.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Stopping during recovery
Date: Tue, 23 Mar 2010 07:52:53 -0400
Message-ID: <d3ab2ec81003230452j23c7942awd0278d57b86d1ed7@mail.gmail.com> (raw)
In-Reply-To: <FDE36E7833B84CDD810DC4A9F14DF40C@squarepi.com>
References: <FDE36E7833B84CDD810DC4A9F14DF40C@squarepi.com>
On Tue, Mar 23, 2010 at 7:18 AM, John Lister
<john.lister-ps@kickstone.com>wrote:
> Hi, I've successfully set up a slave system using WAL archiving and
> pg_standby, but I have a couple of questions.
>
> I have a couple of questions:
>
> Is it possible to stop the database server (for maintenance for example)
> and resume the recovery without starting afresh and making a complete backup
> of the original again?
>
Yes, it won't begin reading at the very first logfile, it will start based
on your last checkpoint:
http://www.scottrmead.com/blogs/scott/warm-standby-monitoringhttp://www.kennygorman.com/wordpress/?p=249> Secondly is it possible to start the database in "readonly" (using set
> default_transaction_read_only) and make a query before resuming the
> recovery?
>
No, this feature is only available in 9.0 (which is in alpha) and beyond.
--Scott M
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: scott.lists@enterprisedb.com, john.lister-ps@kickstone.com
Subject: Re: Stopping during recovery
In-Reply-To: <d3ab2ec81003230452j23c7942awd0278d57b86d1ed7@mail.gmail.com>
* 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