Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8

Hi Avinash,

Thanks for your input.

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

>
> On Wed, Aug 23, 2023 at 6:23 AM Tushar Takate <tushar11(dot)takate(at)gmail(dot)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
>