Thread: postgis update from 2.5 to 3

Re: Michael Böhm 2019-11-12 <CAKJYtEQVW=V3wG9wX4nBoX9Rqti3PfJ7qANNdjO5ztF_3JyZSA@mail.gmail.com>
> As always i wanted to install the newer version beside the current one and
> then do the extension upgrade in postgres. Problem is that installing the
> package "postgresql-10-postgis-3-scripts" tries to overwrite some files
> already provided by " postgresql-10-postgis-2.5-scripts":
> 
> »/usr/share/postgresql/10/applications/shp2pgsql-gui.desktop«
> »/usr/share/postgresql/10/icons/hicolor/16x16/apps/shp2pgsql-gui.png«

Meh. PostGIS installs files in way too many weird places.

> 1. Removing all 2.5-packages, then installing 3 was one solution, but
> "ALTER EXTENSION postgis UPDATE;" afterwards wasn't possible as it
> complained about the missing 2.5-scripts-folder

Interesting... I would have thought that upgrading didn't need the old
files.

> 2. Installing postgis-3(-scripts) with "-o
> Dpkg::Options::="--force-overwrite"" was successful and i could finish the
> upgrade with "ALTER EXTENSION postgis UPDATE;" and "SELECT
> PostGIS_Extensions_Upgrade();"

That's the workaround I would have suggested, yes.

> Is this a packaging-bug, everything working as expected or did i mess up?

Packaging bug. I thought I had tested that, but apparently I had
tested something else. I wonder how I missed that given that
postgresql-10-postgis-3 does depend on postgresql-10-postgis-3-scripts
now, and same for the -2.5 packages. Maybe the problem is only with
older packages.

Which versions of the -2.5 and -3 packages exactly did you use?

Thanks for reporting,
Christoph

Re: Michael Böhm 2019-11-13 <CAKJYtETxgMiGze5hcjhgGOy_4B4wh8YfL6nnKE_UxkwO6iFwjA@mail.gmail.com>
> > Interesting... I would have thought that upgrading didn't need the old
> > files.
> >
> 
> Well it looked like this:
> 
> edugis=# SELECT PostGIS_full_version();
> FEHLER:  konnte nicht auf Datei »$libdir/postgis-2.5« zugreifen: Datei oder
> Verzeichnis nicht gefunden
> KONTEXT:  SQL-Anweisung »SELECT public.postgis_lib_version()«
> PL/pgSQL-Funktion postgis_full_version() Zeile 26 bei SQL-Anweisung

Ok, that's missing the old *libs*, that's somewhat expected.

> > Which versions of the -2.5 and -3 packages exactly did you use?
> >
> 
> Well i always try to update asap so before i had:
> ii  postgresql-10-postgis-2.5            2.5.3+dfsg-2.pgdg100+1
> ii  postgresql-10-postgis-2.5-scripts    2.5.3+dfsg-2.pgdg100+1
> and now
> ii  postgresql-10-postgis-3              3.0.0+dfsg-2~exp1.pgdg100+1
> ii  postgresql-10-postgis-3-scripts      3.0.0+dfsg-2~exp1.pgdg100+1

Thanks, I'll see what I can do about the file conflicts. It will
likely take until next week, however.

Christoph