public inbox for [email protected]help / color / mirror / Atom feed
Replication using patroni on different ubuntu os versions 5+ messages / 2 participants [nested] [flat]
* Replication using patroni on different ubuntu os versions @ 2025-09-16 07:18 OMPRAKASH SAHU <[email protected]> 2025-09-16 07:34 ` Re: Replication using patroni on different ubuntu os versions Ron Johnson <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: OMPRAKASH SAHU @ 2025-09-16 07:18 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication using patroni on different ubuntu os versions 2025-09-16 07:18 Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> @ 2025-09-16 07:34 ` Ron Johnson <[email protected]> 2025-09-16 10:36 ` Re: Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Ron Johnson @ 2025-09-16 07:34 UTC (permalink / raw) To: pgsql-admin On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <[email protected]> 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! ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication using patroni on different ubuntu os versions 2025-09-16 07:18 Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> 2025-09-16 07:34 ` Re: Replication using patroni on different ubuntu os versions Ron Johnson <[email protected]> @ 2025-09-16 10:36 ` OMPRAKASH SAHU <[email protected]> 2025-09-16 13:55 ` Re: Replication using patroni on different ubuntu os versions Ron Johnson <[email protected]> 2025-09-16 13:56 ` Re: Replication using patroni on different ubuntu os versions Ron Johnson <[email protected]> 0 siblings, 2 replies; 5+ messages in thread From: OMPRAKASH SAHU @ 2025-09-16 10:36 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: pgsql-admin 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, <[email protected]> wrote: > On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <[email protected]> > 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! > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication using patroni on different ubuntu os versions 2025-09-16 07:18 Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> 2025-09-16 07:34 ` Re: Replication using patroni on different ubuntu os versions Ron Johnson <[email protected]> 2025-09-16 10:36 ` Re: Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> @ 2025-09-16 13:55 ` Ron Johnson <[email protected]> 1 sibling, 0 replies; 5+ messages in thread From: Ron Johnson @ 2025-09-16 13:55 UTC (permalink / raw) To: pgsql-admin 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 <[email protected]> wrote: > 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, <[email protected]> wrote: > >> On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <[email protected]> >> 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! ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication using patroni on different ubuntu os versions 2025-09-16 07:18 Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> 2025-09-16 07:34 ` Re: Replication using patroni on different ubuntu os versions Ron Johnson <[email protected]> 2025-09-16 10:36 ` Re: Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> @ 2025-09-16 13:56 ` Ron Johnson <[email protected]> 1 sibling, 0 replies; 5+ messages in thread From: Ron Johnson @ 2025-09-16 13:56 UTC (permalink / raw) To: pgsql-admin 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 <[email protected]> wrote: > 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, <[email protected]> wrote: > >> On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <[email protected]> >> 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! ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-09-16 13:56 UTC | newest] Thread overview: 5+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-09-16 07:18 Replication using patroni on different ubuntu os versions OMPRAKASH SAHU <[email protected]> 2025-09-16 07:34 ` Ron Johnson <[email protected]> 2025-09-16 10:36 ` OMPRAKASH SAHU <[email protected]> 2025-09-16 13:55 ` Ron Johnson <[email protected]> 2025-09-16 13:56 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox