On Tue, Mar 11, 2025 at 12:23 PM Paul Foerster <paul.foerster@xxxxxxxxx> 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!
