If you want to follow the following steps to install PostgreSQL, you will want to
- Uninstall any and all existing PostgreSQL packages
- Remove any repositories you added using “one=click Install”
If you don’t know how to do the above, ask.
Start by posting your existing list of repos
Edit - The following should remove your added repo
zypper rr "server:database:postgresql"
You might be able to do a simple “rm” as follows, but might not be sufficient
zypper rm "postgresql*"
I found postgresql10 in the default OSS, you don’t need to install any additional repos.
Note that if you try to install just “postgresql” the current default is PostgreSQL 9.6, so the following describes finding and installing PostgreSQL 10.
The following describes using zypper in an elevated console (using su, but you can “sudo” your commands instead of you wish).
You also have the option to use the YaST Software Manager to perform the same steps.
# zypper se postgresql10
Loading repository data...
Reading installed packages...
S | Name | Summary | Type
| postgresql10 | Basic Clients and Utilities for PostgreSQL | srcpackage
| postgresql10 | Basic Clients and Utilities for PostgreSQL | package
| postgresql10-contrib | Contributed Extensions and Additions to PostgreSQL | package
| postgresql10-devel | PostgreSQL development header files and libraries | package
| postgresql10-docs | HTML Documentation for PostgreSQL | package
| postgresql10-libs | Basic Clients and Utilities for PostgreSQL | srcpackage
| postgresql10-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural languages -> | package
| postgresql10-plpython | The PL/Python Procedural Languages for PostgreSQL | package
| postgresql10-pltcl | PL/Tcl Procedural Language for PostgreSQL | package
| postgresql10-server | The Programs Needed to Create and Run a PostgreSQL Server | package
| postgresql10-test | The test suite for PostgreSQL | package
Since that appears to be what you are looking for, I didn’t look further for PostgreSQL 11.
The following installs the PostgreSQL Client tools, Server, documentation and test suite. You don’t have to install all of these, you can modify for whatever you wish to install
# zypper in postgresql10 postgresql10-docs postgresql10-test
Now you can start your Postgresql Server
systemctl start postgresql
You can set your PostgreSQL Server to start automatically on boot
systemctl enable postgresql
You can verify the running status and settings of your postgresql server
systemctl status postgresql