Re: Replication - Mailing list pgsql-general

From Jonathan Tripathy
Subject Re: Replication
Date
Msg-id 4CCF1F49.5060809@abpni.co.uk
Whole thread Raw
In response to Re: Replication  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Replication
Re: Replication
List pgsql-general
On 01/11/10 20:01, Thomas Kellerer wrote:
> Jonathan Tripathy wrote on 01.11.2010 20:53:
>> Hi Everyone,
>>
>> I'm looking for the best solution for "Hot Standbys" where once the
>> primary server fails, the standby will take over and act just like
>> the master did. 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..
>
> 9.0 has streaming replication and "Hot Standby"
>
> http://www.postgresql.org/docs/current/static/hot-standby.html
> http://www.postgresql.org/docs/current/static/warm-standby.html#STREAMING-REPLICATION
>
>
> Regards
> Thomas
>
>
>
But does that not only allow "read-only" things to work on the standby?

pgsql-general by date:

Previous
From: "Jehan-Guillaume (ioguix) de Rorthais"
Date:
Subject: Re: Why so many xlogs?
Next
From: Merlin Moncure
Date:
Subject: Re: Temporary schemas