Re: Operating system upgrades on PostgreSQL nodes using streaming replication - Mailing list pgsql-admin

From Ron
Subject Re: Operating system upgrades on PostgreSQL nodes using streaming replication
Date
Msg-id 7ab796b5-d60e-404b-a13f-e24ae3a68414@gmail.com
Whole thread Raw
In response to Operating system upgrades on PostgreSQL nodes using streaming replication  (Rahat Agivetova <rahat@ebi.ac.uk>)
Responses Re: Operating system upgrades on PostgreSQL nodes using streaming replication
List pgsql-admin
On 11/8/23 06:29, Rahat Agivetova wrote:
> Hi All,
>
> We are planning to upgrade the operating system from Centos 7 on Primary 
> and Standby PostgreSQL nodes that use streaming replication to RHEL 8.
> What is the recommended order to upgrade OS from Centos 7 to RHEL 8? 
> Standby first, then Primary? Can there be a small time gap between the 
> upgrades or not?

libc change means possible collation change.  That means I'd do them both at 
the same time, then rebuild any indices with TEXT, CHAR or VARCHAR fields.

-- 
Born in Arizona, moved to Babylonia.



pgsql-admin by date:

Previous
From: Rahat Agivetova
Date:
Subject: Operating system upgrades on PostgreSQL nodes using streaming replication
Next
From: Benjamin Acquaye
Date:
Subject: vacuuming postgresql15 issues