Missing postgresql-9.6-postgis-2.3 in jessie-backports

[Bas Couwenberg]

On 2017-11-29 13:11, Jürgen Fuchsberger wrote:
> I want to run postgresql 9.4 and 9.6 in parallel in jessie in order to
> upgrade my database before switching to stretch. My problem is, that I
> run postgis with my database so I also need the corresponding
> postgresql-9.x-postgis packages. While postgresql-9.4,
> postgresql-9.4-postgis-2.3, and postgresql-9.6 are available in
> jessie/jessie-backports, postgresql-9.6-postgis-2.3 is *not*. Is there
> any possibility to include postgresql-9.6-postgis-2.3 to
> jessie-backports since this would greatly help many users who have to
> upgrade their postgis enabled databases.
> 
> Another solution would be including postgresql-9.4-postgis-2.3 into
> stretch, so that it is possible to run the old database after upgrading
> to stretch. Currently the database becomes defunct after upgrade 
> because
> the postgis libraries are missing.

The upgrade scenario is not supported by the Debian package, and is 
unlikely to become supported.

The package in Debian is only build against a single postgresql version.

This problem with upgrades is a known issue, and is something is 
upstream is working on but no solution is available yet.

If you have sufficiently large database that reimporting the data in new 
database is not a viable option, you're better of building postgis 
yourself.

Kind Regards,

Bas