Installing PostgreSQL on RHEL 9 or OL 9 x86_64

Prerequisites

Before you begin the installation process:

• Set up the EDB repository.

  Note

  Rather than use the EDB repository, you can obtain PostgreSQL installers and installation packages from the PostgreSQL community downloads page.

  Setting up the repository is a one-time task. If you have already set up your repository, you don't need to perform this step.

  To determine if your repository exists, enter this command:

  dnf repolist | grep enterprisedb

  If no output is generated, the repository isn't installed.

  To set up the EDB repository:

  1. Go to EDB repositories.

  2. Select the button that provides access to the EDB repository.

  3. Select the platform and software that you want to download.

  4. Follow the instructions for setting up the EDB repository.

• Install the EPEL repository:

  → WrapCopy

  sudo dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm

• Enable additional repositories to resolve dependencies:

  → WrapCopy

  ARCH=$( /bin/arch ) subscription-manager repos --enable "codeready-builder-for-rhel-9-${ARCH}-rpms"

• Disable the built-in PostgreSQL module:

  → WrapCopy

  dnf -qy module disable postgresql

Install the package

sudo dnf -y install postgresql<xx>-server postgresql<xx>-contrib

Where <xx> is the version of PostgreSQL you are installing. For example, if you are installing version 17, the package name would be postgresql17-server postgresql17-contrib.