Installing PostgreSQL on Rocky Linux follows the same procedure as MySQL. We need to enable the PostgreSQL module, install the desired version and enable the PostgreSQL service. Follow the next few steps and you will learn how to install PostgreSQL on Rocky Linux.
Prerequisites
- Rocky Linux 8
- sudo privileges
Install PostgreSQL on Rocky Linux 8
Step 1. Run the system update command.
sudo dnf update
Step 2. To list all the active PostgreSQL versions, run:
sudo dnf module list postgresql
Output:
Rocky Linux 8 - AppStream
Name Stream Profiles Summary
postgresql 9.6 client, server [d] PostgreSQL server and client module
postgresql 10 [d] client, server [d] PostgreSQL server and client module
postgresql 12 client, server [d] PostgreSQL server and client module
postgresql 13 client, server [d] PostgreSQL server and client
module
Step 3. We can see that the default version is 10. Disable it using the following command:
sudo dnf -qy module disable postgresql
Step 4. To install the latest version add the official repo.
sudo dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Step 5. Install the latest PostgreSQL version.
sudo dnf -y install postgresql13 postgresql13-server
Step 6. Initialize the service.
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
Output:
Initializing database ... OK
Step 7. Start and enable the service.
sudo systemctl enable --now postgresql-13
sudo systemctl start postgresql-13
sudo systemctl status postgresql-13
Conclusion
This tutorial shows you how to install the latest PostgreSQL version on Rocky Linux 8. Feel free to leave a comment below and if you find this tutorial useful, follow our official channel on Telegram.