Date: Wed, 18 Nov 2020 22:12:06 +0100
From: Christoph Berg <myon@debian.org>
To: Don Seiler <don@seiler.us>
Cc: pgsql-pkg-debian@lists.postgresql.org
Subject: Re: Ubuntu Unattended Upgrades
Message-ID: <20201118211206.GA412486@msg.df7cb.de>
References: 
 <CAHJZqBBzix3=9dP=kAiLi3Y-YGCJKb=t6F+_L4D+SL7MxX8gtA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAHJZqBBzix3=9dP=kAiLi3Y-YGCJKb=t6F+_L4D+SL7MxX8gtA@mail.gmail.com>
Precedence: bulk

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.

> 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

> 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.)

Christoph