Re: Replication

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Replication
Date: 2010-11-01 20:01:59
Message-ID: ian6bg$1so$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Replication at 2010-11-01 19:53:40 from Jonathan Tripathy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Tripathy 2010-11-01 20:02:30 Re: JDBC Transactions
Previous Message hubert depesz lubaczewski 2010-11-01 19:54:49 Re: Why so many xlogs?