Re: [HACKERS] Hot Standby Failover Scenario

2012-02-28 Thread Greg Smith
On 02/27/2012 10:05 PM, Lucky Haryadi wrote: 3. When Master A fails to service, the database will failovered to Slave B by triggering with trigger file. As soon as you trigger a standby, it changes it to a new timeline. At that point, the series of WAL files diverges. It's no longer

[HACKERS] Hot Standby Failover Scenario

2012-02-27 Thread Lucky Haryadi
Hi everybody. I want to ask about hot-standby related issues. First of all, maybe I will describe my scenario of Postgres master-slave. 1. There are Master A and Slave B in different location, assumed different region of nation. 2. Configuring Master A and Slave B to become hot-standby is same