On Mon, Apr 30, 2012 at 5:00 AM, Greg Williamson <gwilliamso...@yahoo.com>wrote:
> > There is no automatic switchover as far as I know in the streaming > replication -- you have to have identify that there is a failure and > intervene; the switch of a server from standby mode to active is quite fast > in and of itself. Making outside systems award of the new server is > trickier -- perhaps having a VIP which is the connection point to the > outside world, then swap what the VIP points to when you failover to the > backup server. > A shared-IP & Pacemaker/etc is one option. PgBouncer provides a connection pool across a set of replicas and deals with simple health checks - it's straightforward to setup Rob :)
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
