How to recovery failed master after failover - Mailing list pgsql-general

From snowbird
Subject How to recovery failed master after failover
Date
Msg-id 1393913508619-5794524.post@n5.nabble.com
Whole thread Raw
Responses Re: How to recovery failed master after failover  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-general
Hi,

   I am evaluating the HA solution of PostgreSQL 9.3.
        1. Pacemaker resource agent for PostgreSQL + PostgreSQL sync stream
replication
        2. PG-Pool + PostgreSQL sync stream replication
   According to my understanding, above two solution must be done same
things to recovery failed master as new slave after fail over: copy the
database from new master.  Is it necessary operation to recovery failed
master? Does it protect the data consistent after fail over?
   If copy operation is necessary, recovery time very depend on database
size. For example, our database size is 10G, we have to wait for a few
minutes for copying new master data by network.

BRs,
Leo



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-recovery-failed-master-after-failover-tp5794524.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: James Harper
Date:
Subject: Re: multiple results from a function
Next
From: Tatsuo Ishii
Date:
Subject: Re: How to recovery failed master after failover