postgres replication was: Re: [mir-coders] mir high availability
chrisc at indymedia.org
Sat Nov 27 17:21:41 PST 2004
OK some more options fron the postgres admins list:
> erserver, slony, dbmirror are off the top of my head
> for OSS ones ... then Command Prompt has their
> replication solution, so that's four
And pgcluster, which does multi-master.
I can't find downloads for this here...
- dbmirror seems to be included in the distro.
Seems to only synchronous replication
Slony-I looks like the best bet to me but this is just
from having a look around...
On Sun 28-Nov-2004 at 12:35:45AM +0000, Chris wrote:
> On Thu 25-Nov-2004 at 06:08:39PM -0200, Pietro wrote:
> > i'm taking a look at pgreplicator haa anyone used it?
> >  http://pgreplicator.sourceforge.net/
> - Consider using PG Version >= 7.3.1 where replication is
> included in the base distribution
> - Slony-I --- A replication system for PostgreSQL
> Slony-I is a "master to multiple slaves"
> replication system with cascading and failover.
> Slony-I looks promising, there are some docs here:
More information about the mir-coders