Sure! Here's your updated MS Teams message with that phrasing:
Hi Team,
I did a simulation and noticed that Patroni allows a switchover even if the replica is on a different timeline.
Upon checking a few documentations, I learned that timeline mismatch can indicate WAL history divergence, and promoting such a replica may lead to data loss if it's not fully in sync.
📋 Quick pre-switchover checklist:
- ✅ Confirm replica is streaming and caught up (
pg_stat_replication) - ✅ Verify same timeline ID (
pg_controldata) - ✅ Compare WAL receive vs replay LSN
- ✅ Check for missing WALs or gaps in history file
Let me know if anyone needs a quick script to validate these before doing a switchover.
Let me know if you'd like to push this to Confluence as well.
0 comments:
Post a Comment