| 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: | Whole Thread | Raw Message | 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 |