From fa091a626a1df93a2a900bfd804ae027829baaba Mon Sep 17 00:00:00 2001
From: Devrim Gunduz <devrim@gunduz.org>
Date: Tue, 31 Dec 2024 01:08:29 +0300
Subject: [PATCH] Add post-installation steps

---
 templates/pages/extensions/postgis.html | 12 ++++++++++++
 1 file changed, 12 insertions(+)

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">
-- 
2.39.5