| From: | snowbird <dazhoufei(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to recovery failed master after failover |
| Date: | 2014-03-04 06:11:48 |
| Message-ID: | 1393913508619-5794524.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2014-03-04 06:27:26 | Re: How to recovery failed master after failover |
| Previous Message | James Harper | 2014-03-03 23:39:06 | Re: multiple results from a function |