Обсуждение: Replication using patroni on different ubuntu os versions
Hi Team,
Greetings!!
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.
Postgresql version -16
Regards,
OM
On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <sahuop2121@gmail.com> wrote:
Hi Team,Greetings!!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..
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
Hi @Ron,
What if collation is glibc independent i.e inbuilt C.UTF-8? still do we have any chance of inconsistency?
Regards,
OM
On Tue, 16 Sept 2025, 13:05 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <sahuop2121@gmail.com> wrote:Hi Team,Greetings!!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..--Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.<Redacted> lobster!
Be like Project Farm, and test that. 😀 For example, insert records with all sorts of non-ASCII characters (i.e. letters with diacritic marks, œ, æ, other currency symbols etc) into "SELECT text_fld FROM very_big_table_ ORDER BY text_fld" into a csv file on each server, and then take the md5sum.
Testing various regex predicates in WHERE clauses is also a good ise.
If they're not the same, well, you have your answer: it's a problem. If they _are_ the same, then *either* it's not a problem *or* your test data is insufficient.
On Tue, Sep 16, 2025 at 6:36 AM OMPRAKASH SAHU <sahuop2121@gmail.com> wrote:
Hi @Ron,What if collation is glibc independent i.e inbuilt C.UTF-8? still do we have any chance of inconsistency?Regards,OMOn Tue, 16 Sept 2025, 13:05 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <sahuop2121@gmail.com> wrote:Hi Team,Greetings!!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..
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
The bottom line is that it's not supported. You're doing this your own risk.
On Tue, Sep 16, 2025 at 6:36 AM OMPRAKASH SAHU <sahuop2121@gmail.com> wrote:
Hi @Ron,What if collation is glibc independent i.e inbuilt C.UTF-8? still do we have any chance of inconsistency?Regards,OMOn Tue, 16 Sept 2025, 13:05 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <sahuop2121@gmail.com> wrote:Hi Team,Greetings!!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..--Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.<Redacted> lobster!
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!