[postgis-users] options to scaleout POSTGIS DATABASE
robert.coup at onetrackmind.co.nz
Sun Apr 29 16:40:03 PDT 2012
On Mon, Apr 30, 2012 at 5:00 AM, Greg Williamson <gwilliamson39 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users