Re: 9.0 replication -- multiple hot_standby servers - Mailing list pgsql-general

From Alan Hodgson
Subject Re: 9.0 replication -- multiple hot_standby servers
Date
Msg-id 201010291203.57756@hal.medialogik.com
Whole thread Raw
In response to Re: 9.0 replication -- multiple hot_standby servers  ("Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>)
List pgsql-general
On October 29, 2010, "Dean Gibson (DB Administrator)"
<postgresql@ultimeth.com> wrote:
> On 2010-10-29 11:17, Alan Hodgson wrote:
> > I'm curious about this too. It seems that currently I'd have to
> > rebuild any additional slaves basically from scratch to use the new
> > master.
>
> I think so long as you "pointed" (via primary_conninfo) the additional
> slaves to the new (pending) master, before you "touch"ed the pending
> master's trigger file, you should be OK, as all the DBs should be in
> sync at that point.

Yeah they're in sync data-wise, but do they think they're the same WAL
stream for continuity? Would be nice.


--
A hybrid Escalade is missing the point much in the same way that having a
diet soda with your extra large pepperoni pizza is missing the point.

pgsql-general by date:

Previous
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: 9.0 replication -- multiple hot_standby servers
Next
From: "Rob Richardson"
Date:
Subject: Unhandled exception in PGAdmin when opening 16-million-record table