From: John Lister <john.lister-ps@kickstone.com>
To: pgsql-admin@postgresql.org
Subject: Stopping during recovery
Date: Tue, 23 Mar 2010 11:18:37 -0000
Message-ID: <FDE36E7833B84CDD810DC4A9F14DF40C@squarepi.com> (raw)
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?
Secondly is it possible to start the database in "readonly" (using set default_transaction_read_only) and make a query before resuming the recovery?
Thanks
John
--
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/
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: john.lister-ps@kickstone.com
Subject: Re: Stopping during recovery
In-Reply-To: <FDE36E7833B84CDD810DC4A9F14DF40C@squarepi.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