Re: Magnus Hagander 2017-11-11 <CABUevExt7aLarQ2RE5KP9rRUTQSioAxi5FMq=jj9nebtbc+...@mail.gmail.com> > > Is there any way that either the package maintainer or a site > > administrator/programmer such as myself can mark the Postgres server > > packages as "manual upgrade only" or similar? Or since I'm almost certainly > > not the first person to be bitten by this, is there a preferred hack in > > mitigation? > > > Certainly. Unrelated to PostgreSQL, this is a standard feature in Debian. > Commonly used to prevent things like kernel upgrades from happening on the > same schedule as others. > > Basically, you put the package "on hold". See the debian administratino > guide at > https://debian-administration.org/article/67/Preventing_Debian_Package_Upgrades
Another thing you can do is preventing package upgrades from stopping/starting services by using a policy-rc.d: https://jpetazzo.github.io/2013/10/06/policy-rc-d-do-not-start-services-automatically/ https://people.debian.org/~hmh/invokerc.d-policyrc.d-specification.txt However, if you do that, you need to take measures to actually restart into the new version manually later. Christoph -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general