Changes between Version 2 and Version 3 of UsersWikiPostGIS3UbuntuPGSQLApt

Timestamp:

May 29, 2022, 1:14:40 PM (2 years ago)

Author:

robe

Comment:

—

UsersWikiPostGIS3UbuntuPGSQLApt

@@ -156 +156 @@
 
 POSTGIS="3.2.1" [EXTENSION] PGSQL="140" GEOS="3.10.2-CAPI-1.16.0" SFCGAL="SFCGAL 1.4.1, CGAL 5.3.1, BOOST 1.74.0" PROJ="8.2.1" LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
+
+}}}
+
+
+=== Installing postgis_raster, if you need raster support ===
+
+
+{{{
+CREATE EXTENSION postgis_raster SCHEMA postgis;
+SELECT postgis_full_version();
+}}}
+
+Output will be something like below, you should see RASTER in there and GDAL
+{{{
+                      postgis_full_version                                                     
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ POSTGIS="3.2.1" [EXTENSION] PGSQL="140" GEOS="3.10.2-CAPI-1.16.0" SFCGAL="SFCGAL 1.4.1, CGAL 5.3.1, BOOST 1.74.0" PROJ="8.2.1" GDAL="GDAL 3.4.1, released 2021/12/27" LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" RASTER
+(1 row)
+
+}}}
+
+=== Installing postgis_topology ===
+If you need to edit vector data and maintain connectedness across boundaries, then postgis_topology can help with that.
+
+{{{
+CREATE EXTENSION postgis_topology;
+SELECT postgis_full_version();
+}}}
+
+Note the added TOPOLOGY in this output.
+{{{
+                           postgis_full_version                                                
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ POSTGIS="3.3.0dev 0" [EXTENSION] PGSQL="140" GEOS="3.10.2-CAPI-1.16.0" SFCGAL="SFCGAL 1.4.1, CGAL 5.3.1, BOOST 1.74.0" PROJ="8.2.1" GDAL="GDAL 3.4.1, released 2021/12/27" LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER
+
 
 }}}