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.
- 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).
non-root sudo useror 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
Now you are logged in to the PostgreSQL database server. To check login info use the following command from the database command prompt:
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:
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.