postgis update from 2.5 to 3

From: Michael Böhm <dudleyperkins(at)gmail(dot)com>
To: pgsql-pkg-debian(at)lists(dot)postgresql(dot)org
Subject: postgis update from 2.5 to 3
Date: 2019-11-12 13:11:46
Message-ID: CAKJYtEQVW=V3wG9wX4nBoX9Rqti3PfJ7qANNdjO5ztF_3JyZSA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hello,

i tried to upgrade a test-system from postgis 2.5 to 3 and had a little bit
of trouble. Just wanted to let you know about that and ask if my actions
were okay or if can do anything different when upgrading the live-system.

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«
»/usr/share/postgresql/10/icons/hicolor/22x22/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/24x24/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/32x32/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/36x36/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/40x40/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/42x42/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/48x48/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/64x64/apps/shp2pgsql-gui.png«
»/usr/share/postgresql/10/icons/hicolor/8x8/apps/shp2pgsql-gui.png«

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

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();"

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

Regards

Michael

(Please CC me as i'm not subscribed to the list)

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Christoph Berg 2019-11-12 14:39:58 Re: postgis update from 2.5 to 3
Previous Message apt.postgresql.org Repository Update 2019-11-11 10:58:00 repmgr updated to version 5.0.0-3.pgdg+1