Re: Replication - Mailing list pgsql-general

From Jonathan Tripathy
Subject Re: Replication
Date
Msg-id 4CCF4187.8010205@abpni.co.uk
Whole thread Raw
In response to Re: Replication  (Vick Khera <vivek@khera.org>)
Responses Re: Replication  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Replication  (Vick Khera <vivek@khera.org>)
List pgsql-general
On 01/11/10 21:10, Vick Khera wrote:
> On Mon, Nov 1, 2010 at 3:53 PM, Jonathan Tripathy<jonnyt@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?

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Temporary schemas
Next
From: Tom Lane
Date:
Subject: Re: JDBC Transactions