Re: Cross OS version streaming replication - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Cross OS version streaming replication
Date
Msg-id 9f346a8d50f09d3ec73697012b3b763064d8f639.camel@cybertec.at
Whole thread Raw
In response to Cross OS version streaming replication  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List 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



pgsql-admin by date:

Previous
From: Nikhil Shetty
Date:
Subject: Cross OS version streaming replication
Next
From: Christoph Berg
Date:
Subject: Re: Publish DocumentDB packages to PGDG