PostgreSQL - SLES Repo Configuration
Available SuSE repository configuration files
You can use the zypper package manager to install PostgreSQL and/or other components on an SLES 12 host.
zypper will attempt to satisfy package dependencies as it installs a package, but some components require access to specific repositories that are not hosted at postgresql.org, which are described below.
To add PostgreSQL and/or other components, use the following commands to add PostgreSQL community repository configuration files to your SLES host:
PostgreSQL 11 BETA TESTING ONLY, NOT FOR PRODUCTION. USE 10 PACKAGES FOR PRODUCTION
zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-11.repo
PostgreSQL 10
zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-10.repo
PostgreSQL 9.6
zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-96.repo
PostgreSQL 9.5
zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-95.repo
After creating the repository configuration files, use the zypper refresh command to refresh the metadata on your SLES host to include the PostgreSQL SUSE repositories:
Before installing PostgreSQL and/or other supporting components, you must 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 the commands:
zypper install SUSEConnect
SUSEConnect -p PackageHub/12/x86_64
SUSEConnect -p sle-sdk/12/x86_64
For detailed information about registering a SUSE host, visit: https://www.suse.com/support/kb/doc/?id=7016626
Installing PostgreSQL on SLES host
After adding the repo, use the following command to install PostgreSQL to the SLES host:
PostgreSQL 11 CRASH TESTING ONLY!!! NOT EVEN FOR ALPHA TESTING, NOT FOR PRODUCTION. USE 10 PACKAGES FOR PRODUCTION
zypper install postgresql11-server
PostgreSQL 10
zypper install postgresql10-server
PostgreSQL 9.6
zypper install postgresql96-server
PostgreSQL 9.5
zypper install postgresql95-server
Please take a look at the PostgreSQL SuSE package list to see what other packages are available in the repository.
External repositories for some components
Slony:
If you are using a package to add Slony to an SLES host, please note that you must add access to the Perl repository:
For SLES 12 SP2:
zypper addrepo http://download.opensuse.org/repositories/devel:languages:perl/SLE_12_SP2/devel:languages:perl.repo
For SLES 12 SP3:
zypper addrepo http://download.opensuse.org/repositories/devel:languages:perl/SLE_12_SP3/devel:languages:perl.repo
Then:
PostGIS:
When using an RPM package to add PostGIS to an SLES host, you must add the following repository:
zypper addrepo "http://download.opensuse.org/repositories/server:/Kolab:/3.3/SLE_12/server:Kolab:3.3.repo"
Then:
pgAgent
When adding the pgAgent packages to an SLES host, please note that you must add access to the wxWidgets repository:
For SLES 12 SP2:
SUSEConnect -p sle-module-legacy/12/x86_64
SUSEConnect -p sle-sdk/12/x86_64
zypper addrepo http://download.opensuse.org/repositories/X11:/wxWidgets/SLE_12_SP2/X11:wxWidgets.repo
For SLES 12 SP3:
SUSEConnect -p sle-module-legacy/12/x86_64
SUSEConnect -p sle-sdk/12/x86_64
zypper addrepo http://download.opensuse.org/repositories/X11:/wxWidgets/SLE_12_SP3/X11:wxWidgets.repo
Then:
Updating Components on a SLES Host:
To update components installed with zypper, use the zypper update command.