Hello, Le mar. 11 mars 2025 à 17:23, Paul Foerster <paul.foers...@gmail.com> a écrit :
> 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. > It seems to be possible, see this conference talk: https://youtu.be/LFHI58JCm0Q?si=EWeXrKmCURTz_VN- They have performed a linux migration with physical replication, but there are many pitfalls around! I have performed the same kind of migration with logical replication and, in my context, it was far easier! > > 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 version of the glibc binary seems to be a determining factor > > Cheers, > Paul > > HTH, Thomas
