On Fri, 2010-09-24 at 11:43 +0300, Heikki Linnakangas wrote:
> > To get zero data loss *and* continuous availability, you need two
> > standbys offering sync rep and reply-to-first behaviour.
>
> Yes, that is a good point.
>
> I'm starting to understand what your proposal was all about. It makes
> sense when you think of a three node system configured for high
> availability with zero data loss like that.
>
> The use case of keeping hot standby servers up todate in a cluster
> where
> read-only queries are distributed across all nodes seems equally
> important though. What's the simplest method of configuration that
> supports both use cases?
That is definitely the right question. (More later)
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Development, 24x7 Support, Training and Services