pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLinux in-place upgrade
5+ messages / 3 participants
[nested] [flat]
* Linux in-place upgrade
@ 2023-06-26 17:13 Murthy Nunna <mnunna@fnal.gov>
0 siblings, 1 reply; 5+ messages in thread
From: Murthy Nunna @ 2023-06-26 17:13 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi,
We are planning an in-place upgrade of Linux level from RHEL 7 to RHEL 8 or RHEL 9. We have several PG clusters running on this server using different versions of postgres (pg12, pg13 and pg14).
We have couple of plans:
1. Shutdown clusters, unmount disks that contain postgres data and wals, upgrade Linux, remount postgres disks and restart postgres clusters
2. Same as above but reinstall postgres (pg12, pg13 and pg14) before restarting postgres clusters
Questions:
1. Will 1 or 2 or both above work?
2. Is there any official documentation above OS upgrades?
Thank you for reading my post.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Linux in-place upgrade
@ 2023-06-26 17:35 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Murthy Nunna <mnunna@fnal.gov>
0 siblings, 2 replies; 5+ messages in thread
From: Laurenz Albe @ 2023-06-26 17:35 UTC (permalink / raw)
To: Murthy Nunna <mnunna@fnal.gov>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Mon, 2023-06-26 at 17:13 +0000, Murthy Nunna wrote:
> We are planning an in-place upgrade of Linux level from RHEL 7 to RHEL 8 or RHEL 9.
> We have several PG clusters running on this server using different versions of postgres (pg12, pg13 and pg14).
>
> We have couple of plans:
>
> 1. Shutdown clusters, unmount disks that contain postgres data and wals, upgrade Linux,
> remount postgres disks and restart postgres clusters
> 2. Same as above but reinstall postgres (pg12, pg13 and pg14) before restarting postgres clusters
>
> Questions:
> 1. Will 1 or 2 or both above work?
> 2. Is there any official documentation above OS upgrades?
The documentation is here:
https://www.postgresql.org/docs/current/upgrading.html
It depends on how you installed PostgreSQL. If you used binary packages, Option 1 should work fine.
Don't forget to reindex all indexes on strings!
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Linux in-place upgrade
@ 2023-06-26 18:22 Murthy Nunna <mnunna@fnal.gov>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 1 reply; 5+ messages in thread
From: Murthy Nunna @ 2023-06-26 18:22 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Laurenz -
Thanks for responding. The URL posted is taking me to "19.6. Upgrading a PostgreSQL Cluster"... Is there another one that is meant for OS upgrades. We do not want to upgrade postgres, we just want to upgrade OS only.
Thanks again.
-----Original Message-----
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Monday, June 26, 2023 12:36 PM
To: Murthy Nunna <mnunna@fnal.gov>; pgsql-admin@lists.postgresql.org
Subject: Re: Linux in-place upgrade
On Mon, 2023-06-26 at 17:13 +0000, Murthy Nunna wrote:
> We are planning an in-place upgrade of Linux level from RHEL 7 to RHEL 8 or RHEL 9.
> We have several PG clusters running on this server using different versions of postgres (pg12, pg13 and pg14).
>
> We have couple of plans:
>
> 1. Shutdown clusters, unmount disks that contain postgres data and wals, upgrade Linux,
> remount postgres disks and restart postgres clusters
> 2. Same as above but reinstall postgres (pg12, pg13 and pg14) before restarting postgres clusters
>
> Questions:
> 1. Will 1 or 2 or both above work?
> 2. Is there any official documentation above OS upgrades?
The documentation is here:
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.postgresql.org_docs_current_upgrading.html&...
It depends on how you installed PostgreSQL. If you used binary packages, Option 1 should work fine.
Don't forget to reindex all indexes on strings!
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Linux in-place upgrade
@ 2023-06-26 18:35 Jim Mlodgenski <jimmy76@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 5+ messages in thread
From: Jim Mlodgenski @ 2023-06-26 18:35 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Murthy Nunna <mnunna@fnal.gov>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Mon, Jun 26, 2023 at 1:36 PM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Mon, 2023-06-26 at 17:13 +0000, Murthy Nunna wrote:
> > We are planning an in-place upgrade of Linux level from RHEL 7 to RHEL 8
> or RHEL 9.
> > We have several PG clusters running on this server using different
> versions of postgres (pg12, pg13 and pg14).
> >
> > We have couple of plans:
> >
> > 1. Shutdown clusters, unmount disks that contain postgres data and
> wals, upgrade Linux,
> > remount postgres disks and restart postgres clusters
> > 2. Same as above but reinstall postgres (pg12, pg13 and pg14) before
> restarting postgres clusters
> >
> > Questions:
> > 1. Will 1 or 2 or both above work?
> > 2. Is there any official documentation above OS upgrades?
>
> The documentation is here:
> https://www.postgresql.org/docs/current/upgrading.html
>
> It depends on how you installed PostgreSQL. If you used binary packages,
> Option 1 should work fine.
>
> Don't forget to reindex all indexes on strings!
>
> It could be more than just indexes. If there are any partitioned tables
with a partition key of a string, it
could be impacted too. There is a video from the recent PGCon about the
collation changes that
happen going from RHEL7 to RHEL9.
https://www.pgcon.org/events/pgcon_2023/schedule/session/345-sorting-out-glibc-collation-challenges/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Linux in-place upgrade
@ 2023-06-27 04:55 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Murthy Nunna <mnunna@fnal.gov>
0 siblings, 0 replies; 5+ messages in thread
From: Laurenz Albe @ 2023-06-27 04:55 UTC (permalink / raw)
To: Murthy Nunna <mnunna@fnal.gov>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Mon, 2023-06-26 at 18:22 +0000, Murthy Nunna wrote:
> The URL posted is taking me to "19.6. Upgrading a PostgreSQL Cluster"...
Right, my mistake.
Collation changes are the only thing you have to watch out for.
So rebuild indexes on strings (and, as Jim wrote, assess your partitioned tables).
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-06-27 04:55 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-26 17:13 Linux in-place upgrade Murthy Nunna <mnunna@fnal.gov>
2023-06-26 17:35 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-06-26 18:22 ` Murthy Nunna <mnunna@fnal.gov>
2023-06-27 04:55 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-06-26 18:35 ` Jim Mlodgenski <jimmy76@gmail.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