[Pgpool-general] failover with slony

[Brad Nicholson]

Christopher Gorge Marges wrote:

>When the master in a master/slave setup goes down will pgpool
>automatically switch to the slave? The documentation in slony said
>that pgpool would need to be restarted.  Also since failover is not
>automatic in slony, wouldn't that also prevent continuous access to
>the database?
>
>  
>

It would prevent all write access.  Reads would be fine.  Slony puts 
triggers on all replicated tables on subscribers to prevent them being 
written to directly.

-- 
Brad Nicholson  416-673-4106 
Database Administrator, Afilias Canada Corp.