Hi Avinash, Thanks for your input.
On Wed, Aug 23, 2023 at 4:35 PM Avinash Vallarapu < avinash.vallar...@gmail.com> wrote: > > On Wed, Aug 23, 2023 at 6:23 AM Tushar Takate <tushar11.tak...@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 >
