{%extends "base.html" %}
{%block title%}Howto{%endblock%}
{%block maincontent%}

<h1>Postgres - SLES Repo Configuration</h1>

<p>
    You can use the zypper package manager to install Postgres and/or other
    components on an SLES 15 / SLES 12 host. zypper will attempt to satisfy
    package dependencies as it installs a package, but some components (mainly
    PostGIS) require access to specific repositories that are not hosted at
    postgresql.org or SLES official repositories:
	<ul>
	<li>uuid, libjson-c5 : <code>zypper addrepo https://download.opensuse.org/repositories/devel:/libraries:/c_c++/15.6/devel:libraries:c_c++.repo</code></li>
	<li>cfitsio, armadillo, netcdf, hdf5 libqt4 : <code>zypper addrepo https://download.opensuse.org/repositories/science/15.6/science.repo</code></li>
	<li>spatialite-tools (for libosmium) : <code>zypper addrepo https://download.opensuse.org/repositories/Application:/Geo/15.6/Application:Geo.repo</code></li>
	<br>
	<li>freetds-devel (for developers): <code>zypper addrepo https://download.opensuse.org/repositories/devel:languages:misc/SLE_15_SP4/devel:languages:misc.repo</code></li>
	</ul>
</p>

<p>
	Also add SUSEConnect and the SUSE Package Hub extension to the SLES host,
        and register the host with SUSE, allowing access to SUSE repositories. Use
        these commands:
	<br>
	SLES 15 SP 6:
	<br>
	<code>
	 zypper install SUSEConnect<br/>
	 SUSEConnect -p sle-module-desktop-applications/15.6/x86_64</br>
	 SUSEConnect -p PackageHub/15.6/x86_64</br>
	</code>
	<br>
	SLES 15 SP5:
	<br>
	<code>
	 zypper install SUSEConnect<br/>
	 SUSEConnect -p sle-module-desktop-applications/15.5/x86_64</br>
	 SUSEConnect -p PackageHub/15.5/x86_64</br>
	</code>
	<br>
	SLES 12:
	<br>
	<code>
	 zypper install SUSEConnect<br/>
	 SUSEConnect -p PackageHub/12/x86_64<br/>
	 SUSEConnect -p sle-sdk/12/x86_64<br/>
	</code>
</p>

<p>
	For detailed information about registering a SUSE host, visit:
    <a href="https://www.suse.com/support/kb/doc/?id=7016626">https://www.suse.com/support/kb/doc/?id=7016626</a>.
</p>

<p>
    To install Postgres and/or other components, run the following commands to
    add Postgres community repository configuration files to your SLES host:
</p>

<ul>
    <li>SLES 15: <code>rpm --import https://zypp.postgresql.org/keys/PGDG-RPM-GPG-KEY-SLES15; zypper install https://download.postgresql.org/pub/repos/zypp/reporpms/SLES-15-x86_64/pgdg-suse-repo-latest.noarch.rpm</code></li>
</ul>

    <a name="pg15sles">SLES 12:</a>
</p>
<ul>
    <li>SLES 12 / Postgres 15: <code>zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-12-pg15.repo</code></li>
    <li>SLES 12 / Postgres 14: <code>zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-12-pg14.repo</code></li>
    <li>SLES 12 / Postgres 13: <code>zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-13.repo</code></li>
    <li>SLES 12 / Postgres 12: <code>zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-12.repo</code></li>
  </ul>

<p>
    After creating the repository configuration files, use the <code>zypper
    refresh</code> command to refresh the metadata on your SLES host to
    include the Postgres SUSE repositories:
</p>
<p>
	<code>zypper refresh</code>
</p>

<h2>Installing Postgres on SLES host</h2>

<p>
    After adding the repo, use the following command to install Postgres on
    the SLES host:
</p>
<p>
	<a name="pg17install">Postgres 17:</a>
</p>
<p>
	<a name="pg16install">Postgres 17:</a>
</p>
<p>
	<a name="pg15slesinstall"></a>
    <code>zypper install postgresql16-server</code>
</p>

<p>
	<a name="pg15install">Postgres 15:</a>
</p>
<p>
    <a name="pg15slesinstall"></a>
	<code>zypper install postgresql15-server</code>
</p>

<p>
	Please take a look at the <a href="/packages/">Postgres SuSE package
    list</a> to see what other packages are available in the repository.
</p>

{%endblock%}