As part of the manual installation process (which is not recommended), install and configure the PostgreSQL database.

To install and configure the PostgreSQL database:

  1. Install PostgreSQL using the following commands:

    RHEL

    sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
    sudo yum update
    sudo yum install -y postgresql12-server postgresql12-contrib
    /usr/pgsql-12/bin/postgresql-12-setup initdb

    SLES 12

    As of June 2020, the package to install PostgreSQL for SLES 12 SP4 is no longer available at the Open SUSE downloads center. Consider upgrading to SLES 15, contacting your database administrator, or contacting SUSE support for further assistance.

    SLES 15

    zypper addrepo https://download.opensuse.org/repositories/server:/database:/postgresql/SLE_15_SP1/server:database:postgresql.repo
    zypper refresh
    # install PostgreSQL 12
    zypper install postgresql12-server
    zypper install postgresql12-contrib
    # init the db by starting and stopping the postgresql service
    systemctl start postgresql
    systemctl stop postgresql
  2. Update the pg_hba.conf file as needed to enable connections from your RaaS node. Optionally, enable SSL.
  3. Start PostgreSQL and create a database account for the RaaS node. For example:

    RHEL

    systemctl enable postgresql-12
    systemctl start postgresql-12
    sudo su - postgres -c 'createuser -s -P salt_eapi'# This account has Superuser privileges so that# various extensions my be installed.# After initial deployment the Superuser privilege# may be removed.

    SLES 12

    systemctl start postgresql
    su - postgres -c 'createuser -d -P -s root'

    SLES 15

    systemctl start postgresql
    su - postgres -c 'createuser -d -P -s root'

What to do next

After installing and configuring PostgreSQL, the next step is to install and configure the Redis database. See Redis installation and configuration for more information.