From: Florian Weimer <fweimer@bfk.de>
To: pgsql-admin@postgresql.org
Subject: Strategies for validating WAL-shipping replication
Date: Mon, 20 Oct 2008 08:31:08 +0200
Message-ID: <82hc77dbgz.fsf@mid.bfk.de> (raw)
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)?
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.)
--
Florian Weimer <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
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: fweimer@bfk.de
Subject: Re: Strategies for validating WAL-shipping replication
In-Reply-To: <82hc77dbgz.fsf@mid.bfk.de>
* 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