Sorry, if this topic has been already discussed.
I am wondering is there any best practice or guidance on “How to do failover”. Say a cluster of 3 with 1 SR and 1 ASR, we failed over using failkeeper or stopping the master, which promotes the SR to become new master, however, ASR couldn’t follow the newly elected master.
Is pgRewind the only solution to rollback the leading ASR to become SR?
Any suggestions or thoughts are appreciated.