| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Update pg_stat_monitor failed |
| Date: | 2026-11-07 09:57:30 |
| Message-ID: | CANzqJaAN472oPUrHFtDAYqh_BVWk7SAqcworrHSZ=ug-=eG83w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Nov 7, 2026 at 3:25 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> On Fri, 2026-11-06 at 08:39 -0500, Ron Johnson wrote:
> > The sad part is that (if you download the packages beforehand) it takes
> less than
> > 20 seconds to stop the instance, install RPMs and then start the
> instance.
>
> Why is that sad?
>
Because it means there's no good reason to stay unpatched.
> Also, a shutdown can take a while on a busy system, unless you run a
> checkpoint right
> before you shut down.
>
Which means you run a checkpoint just before shutdown.
psql -Xc "CHECKPOINT;"
pg_ctl stop -wt9999
sudo dnf install /path/to/rpms/*rpm
pg_ctl start -wt9999
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2026-11-07 15:51:17 | Re: Update pg_stat_monitor failed |
| Previous Message | Laurenz Albe | 2026-11-07 08:25:14 | Re: Update pg_stat_monitor failed |