On Wed, Nov 18, 2020 at 3:12 PM Christoph Berg <myon@debian.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.
> 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.