MIME-Version: 1.0
From: =?UTF-8?Q?Michael_B=C3=B6hm?= <dudleyperkins@gmail.com>
Date: Tue, 12 Nov 2019 14:11:46 +0100
Message-ID: 
 <CAKJYtEQVW=V3wG9wX4nBoX9Rqti3PfJ7qANNdjO5ztF_3JyZSA@mail.gmail.com>
Subject: postgis update from 2.5 to 3
To: pgsql-pkg-debian@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000033983d059725fe8a"
Precedence: bulk

--00000000000033983d059725fe8a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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":

=C2=BB/usr/share/postgresql/10/applications/shp2pgsql-gui.desktop=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/16x16/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/22x22/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/24x24/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/32x32/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/36x36/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/40x40/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/42x42/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/48x48/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/64x64/apps/shp2pgsql-gui.png=
=C2=AB
=C2=BB/usr/share/postgresql/10/icons/hicolor/8x8/apps/shp2pgsql-gui.png=C2=
=AB

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::=3D"--force-overwrite"" was successful and i could finish th=
e
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)

--00000000000033983d059725fe8a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div>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 d=
ifferent when upgrading the live-system.</div><div><br></div><div>As always=
 i wanted to install the newer version beside the current one and then do t=
he extension upgrade in postgres. Problem is that installing the package &q=
uot;postgresql-10-postgis-3-scripts&quot; tries to overwrite some files alr=
eady provided by &quot;

postgresql-10-postgis-2.5-scripts&quot;:</div><div><br></div><div>=C2=BB/us=
r/share/postgresql/10/applications/shp2pgsql-gui.desktop=C2=AB<br>=C2=BB/us=
r/share/postgresql/10/icons/hicolor/16x16/apps/shp2pgsql-gui.png=C2=AB<br>=
=C2=BB/usr/share/postgresql/10/icons/hicolor/22x22/apps/shp2pgsql-gui.png=
=C2=AB<br>=C2=BB/usr/share/postgresql/10/icons/hicolor/24x24/apps/shp2pgsql=
-gui.png=C2=AB<br>=C2=BB/usr/share/postgresql/10/icons/hicolor/32x32/apps/s=
hp2pgsql-gui.png=C2=AB<br>=C2=BB/usr/share/postgresql/10/icons/hicolor/36x3=
6/apps/shp2pgsql-gui.png=C2=AB<br>=C2=BB/usr/share/postgresql/10/icons/hico=
lor/40x40/apps/shp2pgsql-gui.png=C2=AB<br>=C2=BB/usr/share/postgresql/10/ic=
ons/hicolor/42x42/apps/shp2pgsql-gui.png=C2=AB<br>=C2=BB/usr/share/postgres=
ql/10/icons/hicolor/48x48/apps/shp2pgsql-gui.png=C2=AB<br>=C2=BB/usr/share/=
postgresql/10/icons/hicolor/64x64/apps/shp2pgsql-gui.png=C2=AB<br>=C2=BB/us=
r/share/postgresql/10/icons/hicolor/8x8/apps/shp2pgsql-gui.png=C2=AB<br></d=
iv><div><br></div><div>1. Removing all 2.5-packages, then installing 3 was =
one solution, but &quot;ALTER EXTENSION postgis UPDATE;&quot; afterwards wa=
sn&#39;t possible as it complained about the missing 2.5-scripts-folder</di=
v><div><br></div><div>2. Installing postgis-3(-scripts) with &quot;-o Dpkg:=
:Options::=3D&quot;--force-overwrite&quot;&quot; was successful and i could=
 finish the upgrade with &quot;ALTER EXTENSION postgis UPDATE;&quot; and &q=
uot;<span style=3D"font-size:inherit;white-space:pre-wrap;font-family:inher=
it;font-style:inherit;font-variant:inherit;margin:0px;padding:0px;border:0p=
x;font-weight:bold;font-stretch:inherit;line-height:inherit;vertical-align:=
baseline;color:rgb(153,51,51)">SELECT</span><span style=3D"background-color=
:rgb(242,242,242);font-size:1.05em;white-space:pre-wrap"> PostGIS_Extension=
s_Upgrade</span><span style=3D"font:inherit;white-space:pre-wrap;margin:0px=
;padding:0px;border:0px;vertical-align:baseline;color:rgb(102,204,102)">(</=
span><span style=3D"font:inherit;white-space:pre-wrap;margin:0px;padding:0p=
x;border:0px;vertical-align:baseline;color:rgb(102,204,102)">)</span><span =
style=3D"background-color:rgb(242,242,242);font-size:1.05em;white-space:pre=
-wrap">;</span>&quot;</div><div><br></div><div>Is this a packaging-bug, eve=
rything working as expected or did i mess up?</div><div><br></div><div>Rega=
rds</div><div><br></div><div>Michael</div><div><br></div><div>(Please CC me=
 as i&#39;m not subscribed to the list)</div></div>

--00000000000033983d059725fe8a--