Re: Strategies for validating WAL-shipping replication

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