When we perform a switch-over, the replica fails to start with below errors.
Sharing knowledge is the ultimate key to gaining knowledge..
The only two things that stay with you for life
are you & your knowledge !
Live while you can!
Teach & inspire while you could &
Smile while you have the teeth.. 😉
Wednesday, 8 April 2020
FATAL: requested timeline 3 is not a child of this server's history
When we perform a switch-over, the replica fails to start with below errors.
Switchover - master server and warm standby (with streaming replication) in PostgreSQL
Switch-over of a master database to replica is pretty easy. Lets see how we do it..
I have 2 servers : 5522(data_replica2) and 5432(data), and at this time, 5522 is the master server and 5432 is a warm standby with streaming replication.
I have 2 servers : 5522(data_replica2) and 5432(data), and at this time, 5522 is the master server and 5432 is a warm standby with streaming replication.