Problems upgrading postgresql-9.4 under Debian Jessie

From: Justin Ossevoort <justin(at)quarantainenet(dot)nl>
To: pgsql-pkg-debian(at)postgresql(dot)org
Subject: Problems upgrading postgresql-9.4 under Debian Jessie
Date: 2017-07-10 07:56:41
Message-ID: a11f802e-f4ca-91ac-122c-49be2bf6a1ed@quarantainenet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hello,

Lately we have encountered problems when upgrading the postgresql-9.4
package from apt.postgresql.org under Debian Jessie:

Preparing to unpack .../postgresql-9.4_9.4.12-1.pgdg80+1_i386.deb ...
dpkg: warning: subprocess old pre-removal script returned error exit
status 102
dpkg: trying script from the new package instead ...
dpkg: error processing archive
/var/cache/apt/archives/postgresql-9.4_9.4.12-1.pgdg80+1_i386.deb
(--unpack):
subprocess new pre-removal script returned error exit status 102
Errors were encountered while processing:
/var/cache/apt/archives/postgresql-9.4_9.4.12-1.pgdg80+1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

---

I suspect that the problem is probably related to these changes:

postgresql-common updated to version 183.pgdg+1:
* debian/maintscripts-functions: Unconditionally call invoke-rc.d,
and drop
path names from program invocations (Standards-Version 4.0.0).
* debian/maintscripts-functions: Use 'invoke-rc.d
"postgresql(at)$ver-*" stop'
to prevent upgrading/removing server packages from stopping other major
version clusters when running systemd. (Closes: #809811)

---

Under Debian Jessie these cause the following test at line 467 of
/usr/sbin/invoke-rc.d to fail:

if [ -n "$is_upstart" ] || testexec
"${INITDPREFIX}${INITSCRIPTID}" ; then

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.

---

Running:

touch '/etc/init.d/postgresql(at)9(dot)4-*'
chmod +X '/etc/init.d/postgresql(at)9(dot)4-*'

Causes the upgrade to succeed.

Regards,

Justin Ossevoort

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Christoph Berg 2017-07-10 14:21:25 Re: Problems upgrading postgresql-9.4 under Debian Jessie
Previous Message apt.postgresql.org repository 2017-07-09 14:20:33 mimeo updated to version 1.5.1-1.pgdg+1