Re: Replication - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Replication
Date
Msg-id ian6bg$1so$1@dough.gmane.org
Whole thread Raw
In response to Replication  (Jonathan Tripathy <jonnyt@abpni.co.uk>)
Responses Re: Replication
List pgsql-general
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


pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Why so many xlogs?
Next
From: Jonathan Tripathy
Date:
Subject: Re: JDBC Transactions