<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">
<p>Hello,</p>
<p><br>
</p>
<p>I am planning to move from Postgis 2.5.5 (on PostgreSQL 9.6) to Postgis 3.0 (on PostgreSQL 13).</p>
<p><br>
</p>
<p>I refer to <a href="http://www.postgis.net/docs/postgis_installation.html#hard_upgrade" class="OWAAutoLink" id="LPlnk751322" previewremoved="true">http://www.postgis.net/docs/postgis_installation.html#hard_upgrade</a></p>
<p><br>
</p>
<p>Can I proceed as follows (HARD UPGRADE) ?<a href="http://w" class="OWAAutoLink" id="LPlnk243817" previewremoved="true"></a></p>
<p>- pg_dump database(s) in old system</p>
<p>- install Postgis 3.0 packages on operating system level</p>
<p>- initialization of new database, start the new server, import of users and groups ...</p>
<p></p>
<p>- restore database(s) in new system (using the perl script given in the link above)</p>
<p>- <span>ALTER EXTENSION postgis UPDATE <span>TO "3.0.2"</span>; # in new system</span></p>
<p><span><br>
</span></p>
<p><span><br>
</span></p>
<p>OR</p>
<p><br>
</p>
<p></p>
<div>Is it still necessary to do an in-place SOFT UPGRADE (<span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">ALTER
EXTENSION postgis UPDATE ...) </span>of Postgis 2.5.5 to 3.0 BEFORE starting the procedure above ?</div>
<div><br>
</div>
<div><br>
</div>
<div>There is an older docment which mentions this:</div>
<div><br>
</div>
<div><a href="https://postgis.net/workshops/postgis-intro/upgrades.html#:~:text=34.2.-,Upgrading%20PostGIS,is%20available%20to%20the%20database" class="OWAAutoLink" id="LPlnk870694" previewremoved="true">https://postgis.net/workshops/postgis-intro/upgrades.html#:~:text=34.2.-,Upgrading%20PostGIS,is%20available%20to%20the%20database</a>.</div>
<div><span style="font-size: 12pt;">"Install the new version of PostgreSQL and the same version of PostGIS you are using in your old database. You need to match the PostGIS version so that the dump file function definitions reference an expected version of
the PostGIS library."</span></div>
<div><br>
</div>
<div>Regards,</div>
<div>Martin Reismann</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<p><span><br>
</span></p>
<p><span><br>
</span></p>
<p><span><br>
</span></p>
<p><span><br>
</span></p>
</div>
</body>
</html>