From: | Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Wasim Devale <wasimd60(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Migration from CentOS7 to RHEL red hat Linux |
Date: | 2024-07-30 12:34:55 |
Message-ID: | CAHYHq4XTe_07W8eiL6AE5GXRtUaDqtp7G=re9KDmZ6Vq6Hri9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)sss(dot)pgh(dot)pa(dot)us>님이 작성:
> Wasim Devale <wasimd60(at)gmail(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Muhammad Waqas | 2024-07-30 12:37:46 | Re: Detect who ran DROP schema |
Previous Message | Muhammad Waqas | 2024-07-30 12:32:59 | Re: DR setup in RHOS |