How To Install PostgreSQL on Fedora 36

In this tutorial, we will show you how to install PostgreSQL on Fedora 36. For those of you who didn’t know, PostgreSQL is a powerful, open-source object-relational database system. PostgreSQL has been in active development for over 30 years and has earned a strong reputation in its reliability, robustness, and performance. It is available for Linux, FreeBSD, Solaris, Microsoft Windows, and macOS.

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 14 on a Fedora 36.

Prerequisites

• A server running one of the following operating systems: Fedora 36.
• 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 Fedora 36

Step 1. Before proceeding, update your Fedora operating system to make sure all existing packages are up to date. Use this command to update the server packages:

sudo dnf upgrade
sudo dnf update
sudo dnf install dnf-plugins-core

Step 2. Installing PostgreSQL on Fedora 36.

By default, the PostgreSQL package come in the default repository of Fedora 36. Now run the following command below to add the PostgreSQL repository to your Fedora system:

sudo dnf install https://download.postgresql.org/pub/repos/yum/reporpms/F-36-x86_64/pgdg-fedora-repo-latest.noarch.rpm

After the repository was added, now install PostgreSQL on Fedora 36 using the command below:

sudo dnf install postgresql14-server

Next, initialize the database using the following command:

sudo /usr/pgsql-14/bin/postgresql-14-setup initdb

Once the installation is completed, start the service of the PostgreSQL server and then enable the same, so that it could start itself automatically with the system reboot:

sudo systemctl restart postgresql-14
sudo systemctl status postgresql-14
sudo systemctl enable postgresql-14

Step 3. Configure Firewall.

Firewall configuration is necessary for remote clients to have access to your database. To allow this firewall access, execute the following command:

sudo firewall-cmd --add-service=postgresql --permanent 
sudo firewall-cmd --reload

Step 4. Accessing PostgreSQL Server.

You first need to switch to PostgreSQL default postgres user with the following command:

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 Fedora command prompt:

postgres-# q

Next, create a database by using the following command:

### For example, let us create a new user called “meilana” with password “maria”, and database called “testdb”. ###
sudo -u postgres createuser -D -A -P meilana
sudo -u postgres createdb -O testdb maria

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