On Mon, Nov 1, 2010 at 4:39 PM, Jonathan Tripathy <jon...@abpni.co.uk> wrote: > > On 01/11/10 21:10, Vick Khera wrote: >> >> On Mon, Nov 1, 2010 at 3:53 PM, Jonathan Tripathy<jon...@abpni.co.uk> >> wrote: >>> >>> The standby must support INSERTS and UPDATES as well (once the master has >>> failed) >>> >>> Are there any solutions like this? Looking on the Postgresql site, all >>> the >>> standby solutions seem to be read only.. >> >> If they are RO it is only while they are replicas, not masters. Once >> the server is upgraded to the master role, it becomes RW. >> > So in the "Hot Standby" setup as described in > http://www.postgresql.org/docs/current/static/hot-standby.html , how would I > automatically make the slave a master?
I think you're looking for this: http://www.postgresql.org/docs/current/static/warm-standby-failover.html -- To understand recursion, one must first understand recursion. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general