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.
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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!

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend