Skip site navigation (1) Skip section navigation (2)

Strategies for validating WAL-shipping replication

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Strategies for validating WAL-shipping replication
Date: 2008-10-20 06:31:08
Message-ID: 82hc77dbgz.fsf@mid.bfk.de (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)bfk(dot)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

Responses

pgsql-admin by date

Next:From: wstrzalkaDate: 2008-10-20 08:08:33
Subject: Re: Strategies for validating WAL-shipping replication
Previous:From: Ibrahim HarraniDate: 2008-10-19 15:16:51
Subject: Re: pg_standby and continuous recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group