From: | Tushar Takate <tushar11(dot)takate(at)gmail(dot)com> |
---|---|
To: | Avinash Vallarapu <avinash(dot)vallarapu(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8 |
Date: | 2023-08-24 05:38:39 |
Message-ID: | CAE4W+SKkjDBPSZdbAuMxH_1kZHY9BTAaOC7AM2whNKYGdBfLOg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | jian he | 2023-08-24 05:54:26 | Re: Read only user permission |
Previous Message | Rob Sargent | 2023-08-24 02:12:34 | Re: Read only user permission |