{%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>
<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>

<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)</span></td>
        </tr>
    </tbody>

</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">
    <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</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</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</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</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</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</td>
            <td class="pgyum-available">Available</td>
        </tr>

    </tbody>
</table>

{%endblock%}