| 158 | |
| 159 | }}} |
| 160 | |
| 161 | |
| 162 | === Installing postgis_raster, if you need raster support === |
| 163 | |
| 164 | |
| 165 | {{{ |
| 166 | CREATE EXTENSION postgis_raster SCHEMA postgis; |
| 167 | SELECT postgis_full_version(); |
| 168 | }}} |
| 169 | |
| 170 | Output 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 === |
| 180 | If you need to edit vector data and maintain connectedness across boundaries, then postgis_topology can help with that. |
| 181 | |
| 182 | {{{ |
| 183 | CREATE EXTENSION postgis_topology; |
| 184 | SELECT postgis_full_version(); |
| 185 | }}} |
| 186 | |
| 187 | Note 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 | |