pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOperating system upgrades on PostgreSQL nodes using streaming replication
3+ messages / 3 participants
[nested] [flat]
* Operating system upgrades on PostgreSQL nodes using streaming replication
@ 2023-11-08 12:29 Rahat Agivetova <rahat@ebi.ac.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Rahat Agivetova @ 2023-11-08 12:29 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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?
Thanks,
Rahat
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Operating system upgrades on PostgreSQL nodes using streaming replication
@ 2023-11-08 13:49 Ron <ronljohnsonjr@gmail.com>
parent: Rahat Agivetova <rahat@ebi.ac.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Ron @ 2023-11-08 13:49 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Operating system upgrades on PostgreSQL nodes using streaming replication
@ 2023-11-08 14:52 Keith Fiske <keith.fiske@crunchydata.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Keith Fiske @ 2023-11-08 14:52 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On Wed, Nov 8, 2023 at 8:49 AM Ron <ronljohnsonjr@gmail.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-11-08 14:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-08 12:29 Operating system upgrades on PostgreSQL nodes using streaming replication Rahat Agivetova <rahat@ebi.ac.uk>
2023-11-08 13:49 ` Ron <ronljohnsonjr@gmail.com>
2023-11-08 14:52 ` Keith Fiske <keith.fiske@crunchydata.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox