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: 4cb0d791-1545-442d-888d-9fff4c2b1962@m73g2000hsh.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-admin
There is not such a possibility. However it's on TODO list:
http://wiki.postgresql.org/wiki/Todo
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      http://www.bfk.de/
> 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:http://www.postgresql.org/mailpref/pgsql-admin


In response to

Responses

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-2014 The PostgreSQL Global Development Group