As part of the manual installation process (which is not recommended), install and configure the PostgreSQL database.
To install and configure the PostgreSQL database:
- 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
- Update the
pg_hba.conf
file as needed to enable connections from your RaaS node. Optionally, enable SSL. - 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.