Re: Operating system upgrades on PostgreSQL nodes using streaming replication

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Operating system upgrades on PostgreSQL nodes using streaming replication
Date: 2023-11-08 13:49:44
Message-ID: 7ab796b5-d60e-404b-a13f-e24ae3a68414@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Acquaye 2023-11-08 14:17:57 vacuuming postgresql15 issues
Previous Message Rahat Agivetova 2023-11-08 12:29:36 Operating system upgrades on PostgreSQL nodes using streaming replication