From: Guillaume Lelarge <guillaume@lelarge.info>
To: Florian Weimer <fweimer@bfk.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Strategies for validating WAL-shipping replication
Date: Mon, 20 Oct 2008 10:09:19 +0200
Message-ID: <48FC3CAF.8010600@lelarge.info> (raw)
In-Reply-To: <82hc77dbgz.fsf@mid.bfk.de>
References: <82hc77dbgz.fsf@mid.bfk.de>
Florian Weimer a écrit :
> We've set up WAL-shipping replication on one of our database servers,
> and the question is whether it runs correctly. Is there an easy way
> to access some tables and see if the data matches (possibly in
> single-user mode)?
>
Nope. The only way you can look at data on a "on-recovery" server (the
log shipping slave) is to stop the recovery process.
> Stopping replication and starting the server for real on the replica
> means that we have to set up things from scratch, right? (This is a
> bit annoying because of the amount of data which has to be copied from
> the master.)
>
Yes.
--
Guillaume.
http://www.postgresqlfr.orghttp://dalibo.com
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: guillaume@lelarge.info, fweimer@bfk.de
Subject: Re: Strategies for validating WAL-shipping replication
In-Reply-To: <48FC3CAF.8010600@lelarge.info>
* 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