Re: Moving from Linux to Linux?
Adrian Klaver <adrian.klaver@aklaver.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Paul Foerster <paul.foerster@gmail.com>,
Pgsql-General List <pgsql-general@lists.postgresql.org>
Date: 2025-03-12T20:26:23Z
Lists: pgsql-general
On 3/11/25 11:34, Paul Foerster wrote: > Hi Devrim, Thomas, Adrian, Ron, Joe, > > answering to myself as answering to five postings in one go is impossible. 🤣 > >> Are there any obstacles that definitely make that a no-go? Do I risk corruption? It's both Linux, just a different distribution. > > The question was a bit of an idea. So the glibc version in not known yet, but I'm highly confident that they will differ. A reindex could in theory be possible in most cases, but is a definite show stopper on some of our databases, because it would mean too much application downtime. A good summary of the glibc issue: https://wiki.postgresql.org/wiki/Locale_data_changes With distro information: https://wiki.postgresql.org/wiki/Locale_data_changes#What_Linux_distributions_are_affected > > So, it's either logical replication or close to impossible. > > Thanks very much for your input. > > Cheers, > Paul > -- Adrian Klaver adrian.klaver@aklaver.com