Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration from CentOS7 to RHEL red hat Linux - Mailing list pgsql-admin

From Muhammad Waqas
Subject Re: Migration from CentOS7 to RHEL red hat Linux
Date
Msg-id CAHYHq4XTe_07W8eiL6AE5GXRtUaDqtp7G=re9KDmZ6Vq6Hri9A@mail.gmail.com
Whole thread Raw
In response to Re: Migration from CentOS7 to RHEL red hat Linux  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Migration from CentOS7 to RHEL red hat Linux
List pgsql-admin
Tree view
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@sss.pgh.pa.us>님이 작성:
Wasim Devale <wasimd60@gmail.com> 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


pgsql-admin by date:

Previous
From: Muhammad Waqas
Date:
Subject: Re: DR setup in RHOS
Next
From: Muhammad Waqas
Date:
Subject: Re: Detect who ran DROP schema