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

From Tushar Takate
Subject Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
Date
Msg-id CAE4W+SKkjDBPSZdbAuMxH_1kZHY9BTAaOC7AM2whNKYGdBfLOg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8  (Avinash Vallarapu <avinash.vallarapu@gmail.com>)
List pgsql-general
Hi Avinash,

Thanks for your input. 


On Wed, Aug 23, 2023 at 4:35 PM Avinash Vallarapu <avinash.vallarapu@gmail.com> wrote:

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 ?
-->  The method will depend on data size and the complexity of the data upon which the method will be decided.
Ex - 
1. For less critical/small DB size, This Can be possible with the dump and restore with the small outage.
2. For a Highly transactional system most probably streaming replication will be the method.
3. For Less transactional and less complex data (No extensions like Timescale/PostGIS etc.. .) most probably logical replication will be the method.

Hence, I opened this discussion to understand if there are any other known issues that the PostgreSQL community should be aware of while migrating the database from centos7/RHEL7/OEL7 to RHEL8 via different methods.

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: Rob Sargent
Date:
Subject: Re: Read only user permission
Next
From: jian he
Date:
Subject: Re: Read only user permission