summaryrefslogtreecommitdiff
path: root/templates
diff options
context:
space:
mode:
authorDevrim Gunduz2024-12-30 22:08:29 +0000
committerDevrim Gunduz2024-12-30 22:08:29 +0000
commitfa091a626a1df93a2a900bfd804ae027829baaba (patch)
tree86a36fa0ecb0852f26590ede200674f4d5040eee /templates
parent8cd4c821e1ae7a9ee185362cbc2f043a3f0d42cf (diff)
Add post-installation steps
Diffstat (limited to 'templates')
-rw-r--r--templates/pages/extensions/postgis.html12
1 files changed, 12 insertions, 0 deletions
diff --git a/templates/pages/extensions/postgis.html b/templates/pages/extensions/postgis.html
index 5c4f8a4..12efe45 100644
--- a/templates/pages/extensions/postgis.html
+++ b/templates/pages/extensions/postgis.html
@@ -77,6 +77,18 @@ Enable two repositories for dependencies:<br>
</table>
+<h2>Post-installation</h2>
+<p>
+Connect to the database that you want to create the extension as superuser and run:<br>
+<ul>
+ <li><code>CREATE EXTENSION postgis;</code> # Main extension</li>
+ <li><code>CREATE EXTENSION postgis_raster;</code> # PostGIS raster types and functions</li>
+ <li><code>CREATE EXTENSION postgis_sfcgal;</code> # PostGIS SFCGAL functions</li>
+ <li><code>CREATE EXTENSION postgis_tiger_geocoder CASCADE;</code> # PostGIS tiger geocoder and reverse geocoder. CASCADE is needed for the fuzzystrmatch extension</li>
+ <li><code>CREATE EXTENSION postgis_tiger_topology;</code> # PostGIS topology spatial types and functions</li>
+</ul>
+</p>
+
<h2>Available packages</h2>
<table class="table">