yes you can configure
1 option is to configure stream replication but in such scenario you can only perform fail-over.
2 option is to configure repmgr in which you can perform switchover in postgreSQL
Regards,
Muhammad Waqas
Bitnine
2024년 7월 26일 (금) 오후 7:22, Tom Lane <tgl@xxxxxxxxxxxxx>님이 작성:
Wasim Devale <wasimd60@xxxxxxxxx> writes:
> I want primary and secondary running on CentOS7 in sync with primary and
> secondary running on RHEL. Is it possible by any chance that postgresql
> allows.
If you mean you want to sync something on CentOS7 with something on
RHEL8 or RHEL9, that's pretty dangerous because glibc's collations
will not be the same [1]. You might get away with doing logical
replication, but don't try physical replication.
regards, tom lane
[1] https://wiki.postgresql.org/wiki/Locale_data_changes
