Hi,
(Sorry for the top posting)
Streaming replication won't work between SLES and RHEL, mostly because of glibc incompatibilities. Use logical replication.
Regards, Devrim
(Sorry for the top posting)
Streaming replication won't work between SLES and RHEL, mostly because of glibc incompatibilities. Use logical replication.
Regards, Devrim
On 11 March 2025 16:22:26 GMT, 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.
Cheers,
Paul