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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general