Skip to main content
Version: Next

PostgreSQL

ASI requires PostgreSQL 15+ with the pgcrypto and semver extensions.

There are two installation types, depending on your environment:

  • Database Server — used when hosting PostgreSQL locally/on a dedicated DB node
  • Database Client — required on every ASI node so the installer can run psql

Choose the option that matches your setup.

Repository​

Add the postgreSQL repository to your system

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

Disable the built-in module before installation:

dnf -qy module disable postgresql

Server​

Install the full PostgreSQL server, contrib modules, libraries, and repmgr on Standalone DB or Clustered DB Nodes:

important

If you are using a BES-provided database or any external DB service, you can ignore this step.

# install postgres
dnf install -y postgresql15-server postgresql15 postgresql15-libs postgresql15-contrib repmgr_15
# install semver
dnf install -y https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-8.9-x86_64/semver_15-0.32.1-1PGDG.rhel8.x86_64.rpm

Enable the services:

systemctl enable postgresql-15
systemctl enable repmgr-15

Client​

If your ASI application nodes do not host PostgreSQL themselves, install only the client tools:

dnf install -y postgresql15 postgresql15-libs postgresql15-contrib
  • This installs psql, which is required by the ASI installer.
  • No systemd services are created for client-only installations.