will slony work for this ?

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: will slony work for this ?
Date: 2006-03-16 19:29:32
Message-ID: 4419BC9C.8040808@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have two Postgresql 8.1 servers each one is in a DMZ and each one has
a apache server running on it.
What I want to do is have real time 2 way replication between the two
databases so I can use DNS fail over, i.e when the primary goes down the
secondary would take over.
Then when the primary comes backup it should get all the changes that
happened to the secondary while it was down.

Or would PGCluster be a better option?

Thanks,

Tony

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2006-03-16 19:38:53 Re: [GENERAL] Concurrencia
Previous Message Mario Gonzalez 2006-03-16 19:19:58 Re: [GENERAL] Concurrencia