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
