Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8 - Mailing list pgsql-general

From Avinash Vallarapu
Subject Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
Date
Msg-id CAN0TujfGtTRThiDYNzrOwdYO3Fv6D1puWWaT255iwEQnX=gXrw@mail.gmail.com
Whole thread Raw
In response to PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8  (Tushar Takate <tushar11.takate@gmail.com>)
Responses Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
List pgsql-general

On Wed, Aug 23, 2023 at 6:23 AM Tushar Takate <tushar11.takate@gmail.com> wrote:
Hi Team,

We want to know if there are any open/known issues that we may face post-migration of the DB cluster from centos7/RHEL7/OEL7 to RHEL8.

Depends on the method you choose to perform this migration ? 
If you are using pg_dump and pg_restore for the initial data copy,
followed by logical replication, then, it should be technically okay. 
We came across one issue regarding collation(https://wiki.postgresql.org/wiki/Locale_data_changes), the solution for which is to reindex or use logical replication. In a similar way, we want to understand if there are any other known issues that the community should be aware of.

-
Thanks & Regards,
Tushar K Takate.



--
Regards,
Avinash Vallarapu

pgsql-general by date:

Previous
From: Tushar Takate
Date:
Subject: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
Next
From: Ian Lawrence Barwick
Date:
Subject: Re: [EXTERNAL] Oracle FDW version