Re: Problems upgrading postgresql-9.4 under Debian Jessie

Hello Cristoph,

Thanks for the quick action.

I have installed postgresql-common and postgresql-client-common from
pgdg-testing and made sure I had no lingering
'/etc/init.d/postgresql(at)9(dot)4-*' file.

I then succesfully downgraded and upgraded the postgresql-9.4 package
without errors, so the fix appears to have solved our problems.

Regards,

Justin Ossevoort

On 11-07-17 20:38, Christoph Berg wrote:
> Re: To Justin Ossevoort 2017-07-10 <20170710142125(dot)5tbderithauaiklb(at)msg(dot)df7cb(dot)de>
>> Re: Justin Ossevoort 2017-07-10 <a11f802e-f4ca-91ac-122c-49be2bf6a1ed(at)quarantainenet(dot)nl>
>>> This line effectively checks if we're running upstart (no, we're using
>>> systemd) or if there is an executable in /etc/init.d. Adding a 'set -x' to
>>> the script shows us it checks:
>>>
>>> testexec /etc/init.d/postgresql(at)9(dot)4-*
>>>
>>> Which doesn't exist and this the program exists with code 102, causing the
>>> prerm scrip to fail in turn.
>>
>> Oh, ok. I tested several combinations of OS and with/without systemd,
>> but apparently missed jessie+systemd. Will investigate and publish a
>> fix.
>
> Luckily the fix was pretty easy, namely using deb-systemd-invoke
> instead of invoke-rc.d. New packages are available via the
> *-pgdg-testing suites, it would be nice if you could give them a try.
>
> I'll do some more testing tomorrow and then put them live.
>
> https://anonscm.debian.org/cgit/pkg-postgresql/postgresql-common.git/commit/?id=1a2173a00f7296534d50257d917343117448b39c
>
> Thanks again for the report and the analysis,
> Christoph
>