Re: Cross OS version streaming replication

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Cross OS version streaming replication
Date: 2025-12-03 10:11:54
Message-ID: 9f346a8d50f09d3ec73697012b3b763064d8f639.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Christoph Berg 2025-12-03 17:41:56 Re: Publish DocumentDB packages to PGDG
Previous Message Nikhil Shetty 2025-12-03 08:54:11 Cross OS version streaming replication