[postgis-devel] Debian packaging and upgrade

[Sandro Santilli]

On Thu, Apr 04, 2019 at 05:15:34PM +0200, Paolo Cavallini wrote:
> 
> 
> On 04/04/19 17:00, Sandro Santilli wrote:
> 
> > Sorry, could you be more specific ?
> > Something like showing the output of:
> > 
> >   ls -l /usr/lib/postgresql/11/lib/postgis-2.3.so
> 
> ls -l /usr/lib/postgresql/9.4/lib/postgis-2.1.4.so
> lrwxrwxrwx 1 root root 42 apr  4 17:14
> /usr/lib/postgresql/9.4/lib/postgis-2.1.4.so ->
> /usr/lib/postgresql/9.6/lib/postgis-2.3.so

That's backward, you have the .so under PostgreSQL 9.4
library directory pointing to the .so under PostgreSQL 9.6
library dir.

But now that I think about it, your problem was really
that of lacking the postgis library for the _old_ PostgreSQL.

I really think this is a Debian packaging bug as that library
( /usr/lib/postgresql/9.4/lib/postgis-2.1.4.so ) was removed
as part of upgrading PostGIS, but really needs to exist
independently instead, because PostGIS .so file is bound to
the a specific PostgreSQL version, so it should be packaged
separately (postgresql-9.4-postgis-2.1) and not removed upon
upgrading postgis or postgresql.

--strk;