pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: Real time replication of PG DBs accross two servers - any experiences?
Date: Tue, 13 Apr 2004 23:14:09 -0400
Message-ID: <m3isg36yke.fsf@wolfe.cbbrowne.com> (raw)
References: <407B85CF.4010404@kieser.net>
	<200404132052.12589.peter_e@gmx.net>

A long time ago, in a galaxy far, far away, peter_e@gmx.net (Peter Eisentraut) wrote:
> Bradley Kieser wrote:
>> I desperately need to set up a real time replication of several
>> databases (for failover) between two servers. Last time I looked at
>> the PG replication it wasn't yet production level. I wonder if
>> anyone on this list is doing this successfully and if you won't
>> mind sharing your experience and giving me any tips that you may
>> think would be handy from a real world perspective I would very
>> much appreciate it.
>
> To ensure high availability, using DRBD to replicate the storage or
> using a shared storage (e.g., EMC^2) does the job.  That saves you
> the trouble of having to set up and manage a database replication
> solution at all.

Regrettably, "disk replication" schemes aren't generally able to cope
with keeping the database up and alive while replication is taking
place.

You need to shut down the database that is attached to a
"target/slave" system every time you "sync" the target/slave against
the source/master.

If the _sole_ goal is failover, then that will be defined to be
"fine."

But when the people paying for the duplicate set of hardware realize
that it's sitting there "otherwise useless" at any time that there
hasn't been a failure, they'll presumably agitate for some 'better'
sort of replication...
-- 
(format nil "~S@~S" "cbbrowne" "acm.org")
http://cbbrowne.com/info/lisp.html
"Computers double in speed every  18 months or so, so any "exponential
time" problem  can be solved in  linear time by  waiting the requisite
number of months  for the problem to become solvable  in one month and
then starting the computation."  -- pratt@Sunburn.Stanford.EDU



view thread (8+ messages)  latest in thread

Message-ID: <m3isg36yke.fsf@wolfe.cbbrowne.com>
Permalink:  ../m3isg36yke.fsf@wolfe.cbbrowne.com/
Also on:    postgresql.org/message-id/m3isg36yke.fsf@wolfe.cbbrowne.com

 · 

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: cbbrowne@acm.org
  Subject: Re: Real time replication of PG DBs accross two servers - any experiences?
  In-Reply-To: <m3isg36yke.fsf@wolfe.cbbrowne.com>
  References: <407B85CF.4010404@kieser.net> <200404132052.12589.peter_e@gmx.net> <m3isg36yke.fsf@wolfe.cbbrowne.com>

* 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