From a88ce2a715c6b6ff73c890ebc01549190b591aad Mon Sep 17 00:00:00 2001
From: Devrim Gunduz <devrim@gunduz.org>
Date: Mon, 30 Dec 2024 22:18:18 +0300
Subject: [PATCH] Add initial extensions page and postgis subpage

---
 templates/pages/extensions.html         |  11 ++
 templates/pages/extensions/postgis.html | 163 ++++++++++++++++++++++++
 2 files changed, 174 insertions(+)
 create mode 100644 templates/pages/extensions.html
 create mode 100644 templates/pages/extensions/postgis.html

diff --git a/templates/pages/extensions.html b/templates/pages/extensions.html
new file mode 100644
index 0000000..dc30faa
--- /dev/null
+++ b/templates/pages/extensions.html
@@ -0,0 +1,11 @@
+{% extends "base.html" %}
+{% block title %}Welcome{% endblock %}
+
+{% block maincontent %}
+<h1>Installing PostgreSQL Extensions via RPMs</h1>
+<p>You will find details about installing PostgreSQL extensions on SuSE Enterprise Linux.
+</p>
+</p>
+
+{% endblock %}
+
diff --git a/templates/pages/extensions/postgis.html b/templates/pages/extensions/postgis.html
new file mode 100644
index 0000000..08ec933
--- /dev/null
+++ b/templates/pages/extensions/postgis.html
@@ -0,0 +1,163 @@
+{%extends "base.html" %}
+{%block title%}Extension howto docs{%endblock%}
+{%block maincontent%}
+
+<h1>PostGIS</h1>
+
+<h2>Website</h2>
+<p>
+<a href="https://www.postgis.net" target="_blank">https://www.postgis.net/</a>
+</p>
+
+<h2>Description</h2>
+<p>
+<a href="https://postgis.net" target="_blank">PostGIS</a> adds support for geographic objects
+to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the
+PostgreSQL server, allowing it to be used as a backend spatial database for geographic information
+systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS 
+"Simple Features Specification for SQL" and has been certified as compliant with the
+"Types and Functions" profile.
+</p>
+
+<h2>Package naming convention</h2>
+<p>
+PostGIS uses two digit version numbers like 3.4, 3.5, etc. Traditionally there is a new major 
+release every year along with (but not strictly tied to) the PostgreSQL major release.</br>
+
+The PostgreSQL RPM repository uses both PostGIS and PostgreSQL version numbers in the RPM packages.
+For example PostGIS 3.5 for PostgreSQL 17 is named as <span class="pgyum-warning">postgis35_17</span>.
+Similarly PostGIS 3.2 for PostgreSQL 15 is named as <span class="pgyum-warning">postgis32_14</span>.
+</p>
+
+<h2>Subpackages</h2>
+<p>
+PostGIS provides the following subpackages:
+</p>
+	<ul>
+		<li>client: Provides client tools and their libraries of PostGIS</li>
+		<li>devel: Provides development headers and libraries for PostGIS</li>
+		<li>docs: Provides PDF documentation of PostGIS</li>
+		<li>gui: Provides shp2pgsql-gui binary and related files for PostGIS</li>
+		<li>llvmjit: Provides just-in-time compilation support for PostGIS</li>
+		<li>utils: Provides per utils for PostGIS</li>
+	</ul>
+</p>
+<h2>Package specifications and repository requirements</h2>
+<h3>PostgreSQL PGDG RPM repository</h3>
+<p>Install PGDG repository from: <a href="https://zypp.postgresql.org/repopackages/" target="_blank">https://zypp.postgresql.org/repopackages/</a></p>
+
+<h3>SuSE Enterprise Linux 15</h3>
+<p>
+Enable two repositories for dependencies:<br>
+	<ul>
+		<li>Add Science repo (for cfitsio, armadillo, netcdf, hdf5 libqt4) : <code>zypper addrepo https://download.opensuse.org/repositories/science/15.6/science.repo</code></li>
+		<li>Enable PackageHub:  <code>SUSEConnect -p PackageHub/15.6/x86_64<code></li>
+	</ul>
+</p>
+
+<h2>Installation</h2>
+<p>
+<table class="table">
+    <thead>
+	<tr class="thead-light">
+            <th width="30%">OS</th>
+            <th width="70%">Command</th>
+        </tr>
+    </thead>
+
+    <tbody>
+	<tr>
+            <td>SuSE Enterprise Linux 15</td>
+            <td>zypper install postgis35_17  <span class="pgyum-warning">(or change the version as described above)</span>
+		<br>
+		zypper install postgis35_17-gui <span class="pgyum-warning">(or change "gui" for any subpackage described above)</td>
+	    </td>
+        </tr>
+    </tbody>
+
+</table>
+</p>
+
+<h2>Available packages</h2>
+<p>
+<table class="table">
+    <thead>
+	<tr class="thead-light">
+            <th width="10%">PostGIS version</th>
+            <th width="10%">PostgreSQL version(s)</th>
+            <th width="40%">OS version</th>
+            <th width="10%">Arch</th>
+            <th width="30%">Status</th>
+        </tr>
+    </thead>
+
+    <tbody>
+<!-- 3.5 -->
+	<tr>
+            <td>3.5</td>
+            <td>17,16,15,14,13</td>
+            <td>SuSE Enterprise Linux 15 - x86_64</td>
+            <td>x86_64, aarch64</td>
+            <td class="pgyum-available">Available</td>
+        </tr>
+
+<!-- 3.4 -->
+
+	<tr>
+            <td>3.4</td>
+            <td>17,16,15,14,13</td>
+            <td>SuSE Enterprise Linux 15 - x86_64</td>
+            <td>x86_64, aarch64</td>
+            <td class="pgyum-available">Available</td>
+        </tr>
+
+<!-- 3.3 -->
+
+	<tr>
+            <td>3.3</td>
+            <td>17,16,15,14,13</td>
+            <td>SuSE Enterprise Linux 15 - x86_64</td>
+            <td>x86_64, aarch64</td>
+            <td class="pgyum-available">Available</td>
+        </tr>
+
+<!-- 3.2 -->
+
+	<tr>
+            <td>3.2</td>
+            <td>15,14,13</td>
+            <td>SuSE Enterprise Linux 15 - x86_64</td>
+            <td>x86_64, aarch64</td>
+            <td class="pgyum-available">Available</td>
+        </tr>
+
+<!-- 3.1 -->
+
+	<tr>
+            <td>3.1</td>
+            <td>14,13</td>
+            <td>SuSE Enterprise Linux 15 - x86_64</td>
+            <td>x86_64, aarch64</td>
+            <td class="pgyum-available">Available</td>
+        </tr>
+
+<!-- 3.0 -->
+
+	<tr>
+            <td>3.0</td>
+            <td>13</td>
+            <td>SuSE Enterprise Linux 15 - x86_64</td>
+            <td>x86_64, aarch64</td>
+            <td class="pgyum-available">Available</td>
+        </tr>
+
+    </tbody>
+</table>
+</p>
+
+<h2></h2>
+<p>
+</p>
+
+
+{%endblock%}
-- 
2.39.5