Thread: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
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.
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.Thanks & Regards,
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,
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.-Tushar K Takate.
Thanks & Regards,
Regards,
Avinash Vallarapu
Avinash Vallarapu
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.-Tushar K Takate.
Thanks & Regards,--Regards,
Avinash Vallarapu