Re: Postgres Replication

On Tue, 2007-01-09 at 07:36, dcrespo wrote:
> Hi everybody,
>
> I have two computers with a Postgres Database each. I want one of them
> to be the replica of the other one; let's say I want a Master to Master
> replication in order to use either one (but only one at a time) as the
> main database: in case of failure, switch. The ideal synchronization
> way would be Synchronous. However, these two computers are going to be
> next to each other, so the asynchronous synchronization would be fast
> enough (I don't really know. Can you tell so?) for the case synchronous
> sync is not available.
>
> What I have found so far is Daffodil and Slony-I. Daffodil's name
> doesn't even appear in Postgresql.org, which is not the case for
> Slony-I. So there's a big point in favor to Slony-I.
>
> Has anybody researched on this that can point me in the right
> direction?

Possibly. Depending on your biz requirements, you may be better served
with a hot failover setup, where both machines can mount the same
storage array and if the primary server fails, the secondary server
mounts its partitions and starts up postgresql, and takes over its IPs
etc...

There are hazards with this kind of setup, because if two postmasters
run on the same data store it will corrupt it beyond repair, etc...

slony works well for what you're talking about, but you'll need to come
up with a switchover plan that meets you needs.

You could use possibly use pgpool as long as its caveats aren't a show
stopper (can't insert with random, individual inserts with things like
now() might be a little different, insert order might not be the same on
both machines, etc...

I haven't used daffodil, but have heard of it.

There's also c-jdbc and a few others.