Обсуждение: Cross OS version streaming replication

Поиск
Список
Период
Сортировка

Cross OS version streaming replication

От
Nikhil Shetty
Дата:
Hi Team,

For upgrading the OS from CentOS7 to RHEL8, I plan to create replicas on RHEL8 and then perform a database switchover. After switchover, I will rebuild the indexes affected by glibc change in REHL8. Is this a good option to perform OS upgrades with minimum downtime ? 

Postgres version: 15.12

Thanks,
Nikhil

Re: Cross OS version streaming replication

От
Laurenz Albe
Дата:
On Wed, 2025-12-03 at 14:24 +0530, Nikhil Shetty wrote:
> For upgrading the OS from CentOS7 to RHEL8, I plan to create replicas on RHEL8
> and then perform a database switchover. After switchover, I will rebuild the
> indexes affected by glibc change in REHL8. Is this a good option to perform OS
> upgrades with minimum downtime ?

Yes.  Two remarks:

- Logical replication might be faster, but it way more complicated.

> Postgres version: 15.12

- I'd update to 15.15; you should always run the latest minor release to avoid bugs.

Yours,
Laurenz Albe