Tuesday, November 12, 2013

failover and switchover in postgresql

Question:

For example, I have two servers. First is the primary server and second is the slave server. I need slave server  to become primary (temp) during primary server is down. Then old primary was fixed. I need old primary server is the primary server and then old slave server (new primary (temp)) to become slave server. Pls help me to explain how solve this problem.

Answer:

After performing a failover, the old slave becomes the new master, but the opposite is not true, that is, the old master does not automatically become the slave. We will need to set up replication from the new master to the to-be slave to be able to switch back.

No comments:

Post a Comment