[Pgpool-general] Master and only one slave?

[Brad Nicholson]

On Thu, 2006-08-03 at 12:18 -0700, Jeff Davis wrote:
> On Thu, 2006-08-03 at 14:58 -0400, Brad Nicholson wrote:
> > I think you should plan for the scenario that your slony replica is
> > falling further behind than a planned small lag time.  A burst of
> > traffic, network issues, a slon falling over can all cause a replica to
> > fall further out of sync than you might care for.
> > 
> 
> True, good point. 
> 
> > You also have to be aware of the fact that any write operation that is
> > outside of a transaction might get redirected to the subscriber, which
> > the slony triggers will cause to fail.
> 
> That's only true of a SELECT query that has a write side-effect, right?

Apologies, that part about the write queries is not true.  They always
get sent to the master.  It's just the reads you have to worry about.
Long day...:-)