Bug#866221: postgresql-9.4-postgis-2.1 uninstallable under Stretch

[Élie Bouttier]

Package: postgresql-9.4-postgis-2.1
Severity: normal

Dear Maintainer,

I upgraded from Jessie with postgresql-9.4 to Stretch which brings postgresql-9.6.
The postgresql-9.4 package from Jessie is still installable under Stretch in order to run the pg_upgradecluster utility.
However, my cluster is half-broken, the postgresql-9.4-postgis-2.1 having been uninstalled (and postgresql-9.6-postgis-2.3 installed).
The pg_upgradecluster utility refuse to upgrade my cluster due to the missing module:

pg_dump: [archiver (db)] query failed: ERROR:  could not access file "$libdir/postgis-2.1": No such file or directory

I tried reinstall postgresql-9.4-postgis-2.1 but apt refused:

The following packages have unmet dependencies:
 postgresql-9.4-postgis-2.1 : Depends: libgdal1h (>= 1.9.0) but it is not going to be installed
                              Depends: libgeos-c1 (>= 3.4.2) but it is not going to be installed
                              Depends: liblwgeom-2.1.4 (>= 2.1.2) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

I suppose the postgresql-9.4-postgis-2.1 package should be installable under Stretch (like postgresql-9.4) to allow an cluster update.


Sincerely,

Élie Bouttier


-- System Information:
Debian Release: 9.0
  APT prefers oldstable-updates
  APT policy: (500, 'oldstable-updates'), (500, 'stable'), (500, 'oldstable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-3-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages postgresql-9.4-postgis-2.1 depends on:
ii  libc6                           2.24-11+deb9u1
pn  libgdal1h                       <none>
pn  libgeos-c1                      <none>
pn  liblwgeom-2.1.4                 <none>
pn  libproj0                        <none>
ii  libxml2                         2.9.4+dfsg1-2.2
ii  postgresql-9.4                  9.4.12-0+deb8u1
ii  postgresql-9.4-postgis-scripts  2.1.4+dfsg-3

Versions of packages postgresql-9.4-postgis-2.1 recommends:
ii  postgis                 2.3.1+dfsg-2
ii  postgresql-contrib-9.4  9.4.12-0+deb8u1

postgresql-9.4-postgis-2.1 suggests no packages.