Re: Is there a peer-to-peer server solution with PG? - Mailing list pgsql-general

From David Fetter
Subject Re: Is there a peer-to-peer server solution with PG?
Date
Msg-id 20050204004501.GD27523@fetter.org
Whole thread Raw
In response to Is there a peer-to-peer server solution with PG?  (Mike Nolan <nolan@gw.tssi.com>)
Responses Re: Is there a peer-to-peer server solution with PG?  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
On Thu, Feb 03, 2005 at 06:25:50PM -0600, Mike Nolan wrote:
> I have need to set up a 2nd database server for a client in their
> new offices in another state this month.  We will be shutting down
> the old offices later this year but we really don't want to have 2-3
> days of downtime while we physically transfer equipment 800 miles.
>
> We should have decent data connections between the two offices
> starting next week, but I was wonding if there is a good
> peer-to-peer option for PostgreSQL at this time.
>
> As I understand Slony, it is master-slave only.

Slony-1 is perfectly capable of replicating to a slave database, then
letting you decide to promote it to master, which is just what you'd
need.  Why are you asking about multi-master?

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backing up and restoring a database with the SELinux pg_user problem.
Next
From: Karl Denninger
Date:
Subject: Problem resolved (tsearch2 inhibiting migration)