Re: Replication options?

>From: Peter Eisentraut <peter_e(at)gmx(dot)net>
>To: "Liam Lesboch" <liamlesboch(at)hotmail(dot)com>,pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Replication options?
>Date: Wed, 11 Aug 2004 21:54:28 +0200
>
>Liam Lesboch wrote:
> > Thes slashdots post today about the beta releases of 8.0 caught the
> > attention of my boss and I. Many comments about the replicator issue
> > and saw many posts about Slony-I in particular. Maybe this is the
> > only viable option in PostgreSQL? There are others that cost money
> > but no where did we surface a article that spoke of them in any form
> > of critique or tutorial (good or bad) and thats a concern for my
> > boss. What large companies use replicators for PostgreSQL?
>
>Slony-I and eRServer give you an asynchronous master/slave replication
>system that allows you to setup load balancing or data warehouse type
>things, or even failover with some replication gap. In my experience,
>most people don't need the load balancing part. If all you're after is
>securing your database system against hardware failures (which most
>people are after), I suggest you set up two machines with a shared
>storage (talk to your hardware vendor) or a replicating file system
>(like DRBD) and make the two machines monitor each other so that only
>one machine has the database mounted at any time.
>

The boss is seeking a system located in 5 countries and they have own copy
of master servers in real time. Master->SubMaster(s) (each country) -
>slaves(1-3 each country)

Make sense?

Liam

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail