Re: Strategies for validating WAL-shipping replication - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Strategies for validating WAL-shipping replication
Date
Msg-id 1224510871.3808.695.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Strategies for validating WAL-shipping replication  (Florian Weimer <fweimer@bfk.de>)
List pgsql-admin
On Mon, 2008-10-20 at 08:31 +0200, Florian Weimer wrote:

> We've set up WAL-shipping replication on one of our database servers,
> and the question is whether it runs correctly.

There's two answers here.

The first is that the code used is exactly the same as crash recovery.
So if you trust crash recovery you should trust archive recovery, which
means WAL shipping. The differences are all about where you start and
stop WAL replay.

The second is that any form of replication requires testing.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Strategies for validating WAL-shipping replication
Next
From: "Campbell, Lance"
Date:
Subject: Move tables to tablespace