From: | Keith Fiske <keith(dot)fiske(at)crunchydata(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 14:52:50 |
Message-ID: | CAODZiv5TG3dk0ezFYDpHz2H=iVU0Xh7SKd1Br--fZ_r=X_yOXQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Nov 8, 2023 at 8:49 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
> 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.
>
>
>
See the following wiki page for more information on the collation change
that Ron is referring to
https://wiki.postgresql.org/wiki/Locale_data_changes
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar | 2023-11-08 20:31:27 | Re: Not able to connect specific database |
Previous Message | Keith Fiske | 2023-11-08 14:50:56 | Re: vacuuming postgresql15 issues |