Ganesh Korde <ganeshako...@gmail.com> writes: > On Mon, 22 Feb 2021, 11:48 am Atul Kumar, <akumar14...@gmail.com> wrote: >> I have postgres 9.6 cluster running on Centos 6.8, so I just wanted to >> know that can I configure streaming replication with same postgres version >> i.e 9.6 running on centos 7.
> Should not be a problem if both OS archtecture (32 bit/ 64 bit) are same. The other thing you have to worry about is whether the collations you use sort the same on both systems ... if they don't, you'll have effectively-corrupt indexes on text columns on the standby. According to https://wiki.postgresql.org/wiki/Locale_data_changes you should be okay for rhel/centos 6 to 7 migration unless you use de_DE locale. But I don't know how thorughly that's been checked. Using logical not physical replication might be safer. regards, tom lane
