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)