[postgis-tickets] r16796 - Add instructions about upgrading from pre-3.0.0 postgis extension

Sandro Santilli strk at kbt.io
Fri Sep 14 08:03:56 PDT 2018


Author: strk
Date: 2018-09-14 08:03:56 -0700 (Fri, 14 Sep 2018)
New Revision: 16796

Modified:
   trunk/doc/installation.xml
Log:
Add instructions about upgrading from pre-3.0.0 postgis extension

[ci skip]

Modified: trunk/doc/installation.xml
===================================================================
--- trunk/doc/installation.xml	2018-09-14 14:32:40 UTC (rev 16795)
+++ trunk/doc/installation.xml	2018-09-14 15:03:56 UTC (rev 16796)
@@ -1936,6 +1936,22 @@
 ALTER EXTENSION postgis_topology UPDATE TO "&last_release_version;next";</programlisting>
 		<note><para>If you installed PostGIS originally without a version specified, you can often skip the reinstallation of postgis extension before restoring since the backup just has <code>CREATE EXTENSION postgis</code> and thus
 		picks up the newest latest version during restore.</para></note>
+
+    <note>
+    <para>
+    If you are upgrading PostGIS extension from a version prior to 3.0.0
+    you'll end up with an unpackaged PostGIS Raster support. You can
+    repackage the raster support using:
+    <programlisting>
+    CREATE EXTENSION postgis_raster FROM unpackaged;
+    </programlisting>
+    And then, if you don't need it, drop it with:
+    <programlisting>
+    DROP EXTENSION postgis_raster;
+    </programlisting>
+    </para>
+    </note>
+
 	</sect3>
 
 	</sect2>



More information about the postgis-tickets mailing list