pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: How to do fast, reliable backups?
Date: Sat, 6 Mar 2004 11:30:59 -0500
Message-ID: <20040306163059.GC20089@phlogiston.dyndns.org> (raw)
In-Reply-To: <200403061329.17799.silvanadimartino@tin.it>
References: <200403051637.42457.chris@ruprecht.org>
	<200403061329.17799.silvanadimartino@tin.it>

On Sat, Mar 06, 2004 at 01:39:28PM +0000, Silvana Di Martino wrote:
> a slave replica of your main database server. Should you have any problem 
> with the main server, just switch the IP addresses of the master and slave 
> servers and you are up and running again. The switching takes a few 
> milliseconds and can even be performed automatically by a few specific 
> programs (look for "fault-tolerant linux systems" with google). While your 

And what do you do about the records which made it to the master
database but which haven't been applied on the slave yet?  

Asynchronous replication with automatic failover is _dangerous_,
because you can strand records.  Many commercial systems do this with
what they describe as conflict-management; in truth, this usually
amounts to marking _both_ records as suspect and letting the DBA
decide what to do.

I'm not saying that master-slave systems are a bad idea, but you'd
better be aware of what you're exposing yourself to before
considering such hot-failover cases.  

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca



view thread (6+ messages)  latest in thread

Message-ID: <20040306163059.GC20089@phlogiston.dyndns.org>
Permalink:  ../20040306163059.GC20089@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20040306163059.GC20089@phlogiston.dyndns.org

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: How to do fast, reliable backups?
  In-Reply-To: <20040306163059.GC20089@phlogiston.dyndns.org>
  References: <200403051637.42457.chris@ruprecht.org> <200403061329.17799.silvanadimartino@tin.it> <20040306163059.GC20089@phlogiston.dyndns.org>

* 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