How To Install PostgreSQL on Rocky Linux 9

In this tutorial, we will show you how to install PostgreSQL on Rocky Linux 9. For those of you who didn’t know, PostgreSQL is an immensely popular open-source relational database management system (RDBMS). Generally, it is used as the primary data store for many web, mobile, geospatial, and analytics applications. PostgreSQL can store structured and unstructured data in a single product. In addition, PostgreSQL is open source software, meaning it can be freely used, modified, and distributed.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of PostgreSQL on Rocky Linux. 9.

Prerequisites

• A server running one of the following operating systems:  Rocky Linux 9.
• It’s recommended that you use a fresh OS install to prevent any potential issues.
• SSH access to the server (or just open Terminal if you’re on a desktop).
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install PostgreSQL on Rocky Linux 9

Step 1. The first step is to update your system to the latest version of the package list. To do so, run the following commands:

sudo dnf check-update
sudo dnf install dnf-utils

Step 2. Installing PostgreSQL on Rocky Linux 9.

By default, PostgreSQL is not available on Rocky Linux 9 base repository. Now run the following command below to add the PostgreSQL stable repository to your system:

sudo dnf install http://apt.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Next, run the following command to install the latest stable version of PostgreSQL to your server:

sudo dnf check-update
sudo dnf install postgresql14-server postgresql14-docs

In addition, you can install additional modules, binaries, and libraries in PostgreSQL:

sudo dnf install postgresql14-libs postgresql14-plperl postgresql14-plpython3 postgresql14-pltcl postgresql14-tcl postgresql14-contrib postgresql14-llvmjit

Once the installation is done, start the PostgreSQL service and enable it to automatically start on reboot all in one go with:

sudo systemctl enable postgresql-14 --now
sudo systemctl status postgresql-14

Step 3. Accessing the PostgreSQL command prompt.

Once installing the PostgreSQL database server, by default, it creates a user ‘postgres’ with role ‘postgres’. It also creates a system account with the same name ‘postgres’. So to connect to the Postgres server, log in to your system as a user of Postgres and connect database:

sudo -i -u postgres

You can access a PostgreSQL prompt using the psql utility:

psql

Now you are logged in to the PostgreSQL database server. To check login info use the following command from the database command prompt:

postgres-# \conninfo

To disconnect from the PostgreSQL database command prompt just type the below command and press enter. It will return you back to the Rocky Linux command prompt:

postgres-# \q

Congratulations! You have successfully installed PostgreSQL. Thanks for using this tutorial for installing PostgreSQL 14 on your Rocky Linux 9 system. For additional help or useful information, we recommend you check the official PostgreSQL website.