[postgis-devel] Debian packaging and upgrade

[Sandro Santilli]

On Thu, Apr 04, 2019 at 12:14:04PM +0200, Bas Couwenberg wrote:
> On 2019-04-04 11:58, Sandro Santilli wrote:
> >
> > On postgis-users Paolo reported that using the symlink trick
> > did not work, due to mismatching postgresql server version
> > expected by the .so file. Was this an error on his side,
> > symlinking to the wrong .so file ?
> 
> Possibly.
> 
> When upgrading from stretch to buster you're going from:
> 
>  postgresql-9.6-postgis-2.3 providing:
>   /usr/lib/postgresql/9.6/lib/address_standardizer-2.3.so
>   /usr/lib/postgresql/9.6/lib/postgis-2.3.so
>   /usr/lib/postgresql/9.6/lib/postgis_topology-2.3.so
>   /usr/lib/postgresql/9.6/lib/rtpostgis-2.3.so
> 
> to:
> 
>  postgresql-11-postgis-2.5 providing:
>   /usr/lib/postgresql/11/lib/address_standardizer.so
>   /usr/lib/postgresql/11/lib/postgis-2.5.so
>   /usr/lib/postgresql/11/lib/postgis_topology-2.5.so
>   /usr/lib/postgresql/11/lib/rtpostgis-2.5.so
> 
> So both the version of postgresql and postgis change, as usual for
> distribution upgrades.

Ok, so Paolo must have linked

  /usr/lib/postgresql/11/lib/postgis-2.3.so

to

  /usr/lib/postgresql/9.6/lib/postgis-2.3.so

instead of linking it to

  /usr/lib/postgresql/11/lib/postgis-2.5.so

Do you confirm, Paulo ?

> I consider the symlink hack abhorrent, and personally choose to reimport my
> databases on upgrade as long as pg_upgradecluster doesn't work.

It is technically the exactly same think we obtain
by dropping the minor number, so if one is abhorrent
the other is as well...

--strk;