On Tue, Aug 18, 2009 at 1:25 AM, Yaroslav Tykhiy wrote:
> Encouraged by Bruce Momjian, I tried and had some success in this area. It
> was a controlled failover but it worked like a charm. An obvious condition
> was that the warm standbys be in perfect sync; you can't do the trick if
> some of th
On 18/08/2009, at 9:36 AM, Bryan Murphy wrote:
Ok, I've asked this a few times, but nobody ever responded. I think
I finally got it though, could somebody confirm my logic?
Basically, you setup a chain of servers, and when fails you
replicate to the next link in the chain, like so:
Mast
Ok, I've asked this a few times, but nobody ever responded. I think I
finally got it though, could somebody confirm my logic? Basically, you
setup a chain of servers, and when fails you replicate to the next link in
the chain, like so:
Master (A) --> Warm Standby (B) --> Warn Standby (C) --> etc
Assuming we are running a Postgres instance that is shipping log files to 2
or more warm spares, is there a way I can fail over to one of the spares,
and have the second spare start receiving updates from the new master
without missing a beat? I can live with losing the old master, and at least
at
