Changes between Version 2 and Version 3 of UsersWikiPostGIS3UbuntuPGSQLApt


Ignore:
Timestamp:
05/29/22 13:14:40 (3 years ago)
Author:
robe
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiPostGIS3UbuntuPGSQLApt

    v2 v3  
    156156
    157157POSTGIS="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)"
     158
     159}}}
     160
     161
     162=== Installing postgis_raster, if you need raster support ===
     163
     164
     165{{{
     166CREATE EXTENSION postgis_raster SCHEMA postgis;
     167SELECT postgis_full_version();
     168}}}
     169
     170Output will be something like below, you should see RASTER in there and GDAL
     171{{{
     172                      postgis_full_version                                                     
     173---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     174 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
     175(1 row)
     176
     177}}}
     178
     179=== Installing postgis_topology ===
     180If you need to edit vector data and maintain connectedness across boundaries, then postgis_topology can help with that.
     181
     182{{{
     183CREATE EXTENSION postgis_topology;
     184SELECT postgis_full_version();
     185}}}
     186
     187Note the added TOPOLOGY in this output.
     188{{{
     189                           postgis_full_version                                               
     190------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     191 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
     192
    158193
    159194}}}