[postgis-users] options to scaleout POSTGIS DATABASE

[Robert Coup]

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

Rob :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120430/634dbeb7/attachment.html>