public inbox for [email protected]  
help / color / mirror / Atom feed
From: Adrian Klaver <[email protected]>
To: Paul Foerster <[email protected]>
To: Pgsql-General List <[email protected]>
Subject: Re: Moving from Linux to Linux?
Date: Wed, 12 Mar 2025 13:26:23 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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
[email protected]







view thread (18+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Moving from Linux to Linux?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox