Re: Moving from Linux to Linux?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-General List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Moving from Linux to Linux?
Date: 2025-03-11 16:32:39
Message-ID: CANzqJaDbA-iZ4f8C5V7nmAJr1HH3AGcDNxj-R=2BrMOE8vPD3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 11, 2025 at 12:23 PM Paul Foerster <paul(dot)foerster(at)gmail(dot)com>
wrote:

> Hi,
>
> we are considering changing the PostgreSQL platform from SUSE SLE to Red
> Hat. To keep service interruptions as short as possible, the idea is to set
> up a streaming replication from the SUSE server to be replaced to a
> temporary Red Hat server and then replace that SUSE server with the newly
> setup Red Hat server.
>
> My idea is to set up a streaming replication for this. But this of course
> only works if the data files would be binary compatible.
>
> So, I wonder, if this is possible. We have a lot of databases, some of
> them need to be highly available and some are large too.
>
> Are there any obstacles that definitely make that a no-go? Do I risk
> corruption? It's both Linux, just a different distribution.
>

The same version of PG will be on both, right?

What version of RHEL? What version of SLES? Those questions are proxy
for: what version of glibc on each system?

If they're the same, and you use libc for collation, then you're (probably)
good to go.

If they're different, then you should use logical replication. Otherwise,
string collation mismatch could bite you on any indices on text fields.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2025-03-11 16:36:40 Re: Moving from Linux to Linux?
Previous Message Adrian Klaver 2025-03-11 16:32:28 Re: Moving from Linux to Linux?