Hello Markus, I successfully upgraded to postgresql 9.6 using postgresql-9.4-postgis-2.3 from PgApt (and some ALTER EXTENSION postgis UPDATE TO "2.3.2"; in relevant databases).
Thank you very much for your answer. Best Regards, Élie Bouttier On 28/06/2017 15:59, Markus Wanner wrote: > 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 >