On Tue, 2009-02-24 at 16:55 +0000, Thom Brown wrote:
> We're looking at setting up a warm-standby server using log shipping
> and aren't too sure about how we should trigger failover. Is there a
> commonly-used approach which is reliable enough to recommend? Looking
> at the documentation, there doesn't seem to be any recommendation. I
> preferrably don't want to use a witness server.
>
> Also, what would you say is the best way to tell the failed primary
> server that it is no longer the primary server?
http://www.postgresql.org/docs/8.3/static/pgstandby.html
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support