Re: Replication

From: Jonathan Tripathy <jonnyt(at)abpni(dot)co(dot)uk>
To: Vick Khera <vivek(at)khera(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Replication
Date: 2010-11-01 22:39:03
Message-ID: 4CCF4187.8010205@abpni.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 01/11/10 21:10, Vick Khera wrote:
> On Mon, Nov 1, 2010 at 3:53 PM, Jonathan Tripathy<jonnyt(at)abpni(dot)co(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-11-01 22:53:45 Re: JDBC Transactions
Previous Message Thomas Kellerer 2010-11-01 22:28:56 Re: Temporary schemas