On 3/11/25 12:30, Devrim Gündüz wrote:
> Streaming replication won't work between SLES and RHEL, mostly because
> of glibc incompatibilities. Use logical replication.
To be clear, it probably will "work" for some definition of "work" as
long as the architecture is the same. In other words if you try it, it
might well appear to work ok.
However as Devrim correctly points out, differences in glibc versions
almost certainly will mean that you will have corrupt indexes on
collatable columns. These indexes can be fixed via REINDEX, but if you
don't do that *before* allowing any DML you risk further complications
such as inability to REINDEX due to duplicate primary key values.
HTH,
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
