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

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.

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.