| 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)
| 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 |