Re: PostGreSQL Replication question !! - Mailing list pgsql-general

From Gregory Wood
Subject Re: PostGreSQL Replication question !!
Date
Msg-id 09f401c2d6b9$de32cc00$4f89ffcc@eng3
Whole thread Raw
In response to PostGreSQL Replication question !!  (eric.cros@b2i-toulouse.com (Eric Cros))
Responses Re: PostGreSQL Replication question !!  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
> i'm about to start working on using dbmirror for a project. i'd say that
in
> its current state, it's not complete, but it can be persuaded to serve in
a
> useful way. it lacks conflict resolution,

Agreed, but it's meant to be one way, so...

> and it currently replicates one
> master to one slave (but can be coached into something more
comprehensive.)

Actually it handles multi-slave easily... that's why there's a "MirrorHost"
table. I'm currently replicating out to two slaves with no modifications.

> it also makes assumptions about the initial states of the databases
> involved replication.

Yes, which makes it a true pain in the ass to bring another slave online.

Greg


pgsql-general by date:

Previous
From: Richard Welty
Date:
Subject: Re: PostGreSQL Replication question !!
Next
From: Dennis Gearon
Date:
Subject: Re: PostGreSQL Replication question !!