Re: Ubuntu Unattended Upgrades

On Wed, Nov 18, 2020 at 3:12 PM Christoph Berg <myon(at)debian(dot)org> wrote:

> Re: Don Seiler
> > We had assumed since unattended-upgrade doesn't include PGDG that it
> > wouldnt upgrade the existing packages, but apparently that doesn't
> prevent
> > it from "upgrading" them to the Ubuntu equivalent, which then also
> restarts
> > the databases. It seems this is only a problem with postgresql-10 on
> Ubuntu
> > Bionic since Bionic provides its own postgresql-10 packages.
>
> Hmm, I wasn't aware that Ubuntu's (?) default unattended-upgrades
> config makes it upgrade Ubuntu packages only.
>

By default it only upgrades from an approved list of sources. One could
include PGDG repos in that list if you desired.

> > Alternatively, is it possible to install the new packages but *NOT*
> restart
> > the DB automatically? I understand that a DB restart would be required to
>
> You can install a /usr/sbin/policy-rc.d file [1]. That will allow
> filtering the start/stop actions issued by package activity.
>
> [1] https://people.debian.org/~hmh/invokerc.d-policyrc.d-specification.txt

I'll look into this, thanks!

>
>
> > run on the new version but curious if we could have the packages
> installed
> > prior and then restart at the next available window (although
> installation
> > doesn't really take that long, just curious).
>
> Restarting after install is actually the default since a while ago.
> (Previously packages were doing stop-upgrade-start.)
>

Right but I mean restarting like later in the day or week. Not immediately
after the upgrade when we aren't ready for it.

Thanks for all the info!

Don.

--
Don Seiler
www.seiler.us