From: Simon Riggs <simon@2ndQuadrant.com>
To: Florian Weimer <fweimer@bfk.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Strategies for validating WAL-shipping replication
Date: Mon, 20 Oct 2008 14:54:31 +0100
Message-ID: <1224510871.3808.695.camel@ebony.2ndQuadrant> (raw)
In-Reply-To: <82hc77dbgz.fsf@mid.bfk.de>
References: <82hc77dbgz.fsf@mid.bfk.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndQuadrant.com, fweimer@bfk.de
Subject: Re: Strategies for validating WAL-shipping replication
In-Reply-To: <1224510871.3808.695.camel@ebony.2ndQuadrant>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox