Re: Migration from CentOS7 to RHEL red hat Linux

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
>
>
>

In response to

Responses

Browse pgsql-admin by date

  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