Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B8C776501F2
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 20 Oct 2008 05:09:31 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 57343-10 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 20 Oct 2008 05:09:24 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192])
	by postgresql.org (Postfix) with ESMTP id 5732864FE39
	for <pgsql-admin@postgresql.org>; Mon, 20 Oct 2008 05:09:23 -0300 (ADT)
Received: from [192.168.10.64]
	(ASte-Genev-Bois-153-1-58-150.w81-249.abo.wanadoo.fr
	[81.249.208.150])
	by sd-2317.dedibox.fr (Postfix) with ESMTP id 6D3E53441;
	Mon, 20 Oct 2008 10:09:19 +0200 (CEST)
Message-ID: <48FC3CAF.8010600@lelarge.info>
Date: Mon, 20 Oct 2008 10:09:19 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 2.0.0.17 (X11/20080925)
MIME-Version: 1.0
To: Florian Weimer <fweimer@bfk.de>
CC: pgsql-admin@postgresql.org
Subject: Re: Strategies for validating WAL-shipping replication
References: <82hc77dbgz.fsf@mid.bfk.de>
In-Reply-To: <82hc77dbgz.fsf@mid.bfk.de>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.899 tagged_above=0 required=5
	tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72
X-Spam-Level: *
X-Archive-Number: 200810/131
X-Sequence-Number: 30587

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.org
 http://dalibo.com