Hello Élie, On 06/28/2017 03:28 PM, Élie Bouttier wrote: > 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).
that's what the pgapt [0] repository is for. Please try installing postgresql-9.4-postgis-2.1 (for stretch) from there. > I suppose the postgresql-9.4-postgis-2.1 package should be installable under > Stretch (like postgresql-9.4) to allow an cluster update. No, postgresql-9.4-postgis-2.1 from jessie is expected to be compiled and work for jessie, not stretch. The problem basically is that Debian only ever supports a single Postgres (major) version, where as you need to have multiple installed in parallel for upgrades (with reasonably short downtimes). Please let us know if pgapt is a feasible solution for you and whether or not the upgrade worked with the postgis package from there. Kind Regards Markus Wanner [0]: PgApt https://wiki.postgresql.org/wiki/Apt
signature.asc
Description: OpenPGP digital signature