I have 3 node patroni postgresql cluster in which primary and replica is running on Ubuntu 20 and third one is running on Ubuntu 24 that is in DR region.
So if we do the switch over on DR and then switch back to primary region, is there any chance of data corruption due to OS version mismatch.
The problem is that corruption in text indices can happen due to collation changes from gnu libc version upgrades..