Postgres Replication

From: "dcrespo" <dcrespo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Replication
Date: 2007-01-09 13:36:14
Message-ID: 1168349774.397311.309940@38g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks a lot,

Daniel Crespo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-01-09 13:40:45 Re: Questions about horizontal partitioning
Previous Message Chander Ganesan 2007-01-09 13:28:29 Re: Questions about horizontal partitioning