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

Re: Strategies for validating WAL-shipping replication

From: wstrzalka <wstrzalka(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Strategies for validating WAL-shipping replication
Date: 2008-10-20 08:08:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
There is not such a possibility. However it's on TODO list:
I'm waiting for this feature too.

I can understand your fear about the data, that you can not query for
it. I had the same :)
So script as much as you can, for the rest create a formal procedure -
then repeat it few times and check if everything is correct. After
several tries you'll believe your data are safe. I've a good comfort
level with this.
You can also check & resetup your production from time to time.

On Oct 20, 8:31 am, fwei(dot)(dot)(dot)(at)bfk(dot)de (Florian Weimer) wrote:
> 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                <fwei(dot)(dot)(dot)(at)bfk(dot)de>
> BFK edv-consulting GmbH
> Kriegsstraße 100              tel: +49-721-96201-1
> D-76133 Karlsruhe             fax: +49-721-96201-99
> --
> Sent via pgsql-admin mailing list (pgsql-ad(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-admin by date

Next:From: Guillaume LelargeDate: 2008-10-20 08:09:19
Subject: Re: Strategies for validating WAL-shipping replication
Previous:From: Florian WeimerDate: 2008-10-20 06:31:08
Subject: Strategies for validating WAL-shipping replication

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