Re: Warm standby failover mechanism

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