Re: failover - Mailing list pgsql-novice

From Josh Berkus
Subject Re: failover
Date
Msg-id 200401161111.14510.josh@agliodbs.com
Whole thread Raw
In response to failover  (Bryan Irvine <bryan.irvine@kingcountyjournal.com>)
List pgsql-novice
Bryan,

> How can you sync 2 database to be identical in the case of a failover,
> where one server goes down, the other already has all of the correct
> info, then if the primary comes live, the secondary sync's all of it
> data back?

With a lot of work.  Or by paying $$$$ to a contractor.

Or by waiting to Jan Wieck's new replication engine, expected in 6 months or
so.

What's your deadline & params?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-novice by date:

Previous
From: "Chris"
Date:
Subject: ECPG
Next
From: "Alan T. Miller"
Date:
Subject: changing start value of sequence after it was created...