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

[Élie Bouttier]

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
>