Thread: Migration from CentOS7 to RHEL red hat Linux
Hi Everyone
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.
I have done some analysis and came to know that Kafka tool can do this but any provision from postgresql?
Thanks,
Wasim
On Fri, Jul 26, 2024 at 2:20 AM Wasim Devale <wasimd60@gmail.com> wrote:
Hi EveryoneI 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.
Technically, yes, but I recommend against that because CentOS7 and the unspecified RHEL version might have different glibc versions (thus different collations, and so PKs, FKs, queries, etc might fail).
OTOH, logical replication would work just fine between CentOS7 and your unspecified RHEL version. (Lots of metadata updates would complicate that, though.)
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
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
> On Jul 30, 2024, at 6:34 AM, Muhammad Waqas <waqas.m@bitnine.net> wrote: > > 1 option is to configure stream replication but in such scenario you can only perform fail-over. To be a little pedantic, you *can* perform switchover, but there are a number of steps to it, and I wouldn't recommend tryingit.
Hello,
You don't need any complex steps.
Just made streaming replication. If you want to migrate your database from centos to Redhat, close the apps and then make a failover on your replica server.
Have a nice day.
Scott Ribe <scott_ribe@elevated-dev.com>, 30 Tem 2024 Sal, 16:35 tarihinde şunu yazdı:
> On Jul 30, 2024, at 6:34 AM, Muhammad Waqas <waqas.m@bitnine.net> wrote:
>
> 1 option is to configure stream replication but in such scenario you can only perform fail-over.
To be a little pedantic, you *can* perform switchover, but there are a number of steps to it, and I wouldn't recommend trying it.