public inbox for [email protected]help / color / mirror / Atom feed
Moving from Linux to Linux? 3+ messages / 3 participants [nested] [flat]
* Moving from Linux to Linux? @ 2025-03-11 16:22 Paul Foerster <[email protected]> 2025-03-11 16:30 ` Re: Moving from Linux to Linux? Devrim Gündüz <[email protected]> 2025-03-11 16:32 ` Re: Moving from Linux to Linux? Ron Johnson <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Paul Foerster @ 2025-03-11 16:22 UTC (permalink / raw) To: Pgsql-General List <[email protected]> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Moving from Linux to Linux? 2025-03-11 16:22 Moving from Linux to Linux? Paul Foerster <[email protected]> @ 2025-03-11 16:30 ` Devrim Gündüz <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Devrim Gündüz @ 2025-03-11 16:30 UTC (permalink / raw) To: [email protected]; Paul Foerster <[email protected]> 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 On 11 March 2025 16:22:26 GMT, Paul Foerster <[email protected]> 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 > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Moving from Linux to Linux? 2025-03-11 16:22 Moving from Linux to Linux? Paul Foerster <[email protected]> @ 2025-03-11 16:32 ` Ron Johnson <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Ron Johnson @ 2025-03-11 16:32 UTC (permalink / raw) To: Pgsql-General List <[email protected]> On Tue, Mar 11, 2025 at 12:23 PM Paul Foerster <[email protected]> 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! ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-03-11 16:32 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-03-11 16:22 Moving from Linux to Linux? Paul Foerster <[email protected]> 2025-03-11 16:30 ` Devrim Gündüz <[email protected]> 2025-03-11 16:32 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox