Installing PostgreSQL on AlmaLinux 9 or Rocky Linux 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
```
sudo dnf -y install epel-release
```
Enable additional repositories to resolve dependencies
```
sudo dnf config-manager --set-enabled powertools
```
Enable additional repositories to resolve dependencies
```
dnf config-manager --set-enabled powertools
```
Disable the built-in PostgreSQL module
```
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 15, the package name would be postgresql15-server postgresql15-contrib.

Could this page be better? Report a problem or suggest an addition!