MIME-Version: 1.0
References: 
 <CAHJZqBBzix3=9dP=kAiLi3Y-YGCJKb=t6F+_L4D+SL7MxX8gtA@mail.gmail.com>
 <20201118211206.GA412486@msg.df7cb.de>
In-Reply-To: <20201118211206.GA412486@msg.df7cb.de>
From: Don Seiler <don@seiler.us>
Date: Wed, 18 Nov 2020 15:21:03 -0600
Message-ID: 
 <CAHJZqBD6BzWULjtJu6L4d_eTf0b8i7qN8D_OoONTQZEmsuzFNQ@mail.gmail.com>
Subject: Re: Ubuntu Unattended Upgrades
To: Christoph Berg <myon@debian.org>
Cc: pgsql-pkg-debian@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f36f1905b46830e5"
Precedence: bulk

--000000000000f36f1905b46830e5
Content-Type: text/plain; charset="UTF-8"

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

--000000000000f36f1905b46830e5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Nov 18, 2020 at 3:12 PM Christoph=
 Berg &lt;<a href=3D"mailto:myon@debian.org">myon@debian.org</a>&gt; wrote:=
<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-left:1ex">Re: Don Seiler<br>
&gt; We had assumed since unattended-upgrade doesn&#39;t include PGDG that =
it<br>
&gt; wouldnt upgrade the existing packages, but apparently that doesn&#39;t=
 prevent<br>
&gt; it from &quot;upgrading&quot; them to the Ubuntu equivalent, which the=
n also restarts<br>
&gt; the databases. It seems this is only a problem with postgresql-10 on U=
buntu<br>
&gt; Bionic since Bionic provides its own postgresql-10 packages.<br>
<br>
Hmm, I wasn&#39;t aware that Ubuntu&#39;s (?) default unattended-upgrades<b=
r>
config makes it upgrade Ubuntu packages only.<br></blockquote><div><br></di=
v><div>By default it only upgrades from an approved list of sources. One co=
uld include PGDG repos in that list if you desired.</div><div>=C2=A0</div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex">
&gt; Alternatively, is it possible to install the new packages but *NOT* re=
start<br>
&gt; the DB automatically? I understand that a DB restart would be required=
 to<br>
<br>
You can install a /usr/sbin/policy-rc.d file [1]. That will allow<br>
filtering the start/stop actions issued by package activity.<br>
<br>
[1] <a href=3D"https://people.debian.org/~hmh/invokerc.d-policyrc.d-specifi=
cation.txt" rel=3D"noreferrer" target=3D"_blank">https://people.debian.org/=
~hmh/invokerc.d-policyrc.d-specification.txt</a></blockquote><div><br></div=
><div>I&#39;ll look into this, thanks!</div><div>=C2=A0</div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex"><br>
<br>
&gt; run on the new version but curious if we could have the packages insta=
lled<br>
&gt; prior and then restart at the next available window (although installa=
tion<br>
&gt; doesn&#39;t really take that long, just curious).<br>
<br>
Restarting after install is actually the default since a while ago.<br>
(Previously packages were doing stop-upgrade-start.)<br></blockquote><div><=
br></div><div>Right but I mean restarting like later in the day or week. No=
t immediately after the upgrade when we aren&#39;t ready for it.</div><div>=
<br></div><div>Thanks for all the info!</div><div><br></div><div>Don.=C2=A0=
</div></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr"><div>Don Seiler<br><a href=3D"http://=
www.seiler.us" target=3D"_blank">www.seiler.us</a></div></div></div></div>

--000000000000f36f1905b46830e5--