PostgreSQL database installation and configuration

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.