Install base software

Preparations

Make sure that the installation host can establish a connection to the Internet to download software packages via YUM. Checkout the repository download site [YUM PgSQL Repository] and note down the complete URL of the required RPM package for your desired architecture. This URL has to be used in step 2 below.

In the following example a 64-bit RHEL 7 compatible system (CentOS) is used.

Installation steps

Execute the following steps to install the base software.

  1. Log in as a user with enough permissions to install packages via YUM.

  2. Adjust the highlighted part in the following illustration, so it reflects the matching package for your architecture, and then execute the yum install command:

    yum install -y "https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm"

  3. Adjust the highlighted part (with your PostgreSQL version number if it is different from 12) and execute the yum install command for PostgreSQL server:1

    yum install -y postgresql12-server

The installation will create a system account “postgres” who will be the owner of the database system files. By default this account is locked and cannot be used to log in.