Search Postgresql Archives

How to recovery failed master after failover

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux