We are celebrating the launch of Fedora 34. So we are aware that many developers use it to do their daily work. So they probably need to install some database manager. We recently explained how to install Lamp in Fedora and there you could learn how to install MariaDB. However, it is true that many developers prefer to use PostgreSQL because of its performance. So, in this post, I will teach you how to install PostgreSQL on Fedora 34.
It is not necessary talk much about PostgreSQL. However, very briefly I will explain you what it is. It is a SQL database manager, open source and well known by application developers. Mainly because it has a considerably superior performance to others like MariaDB or MySQL. So we will have enterprise power in a community program. Sounds good, no?
PostgreSQL has an updated repository for Fedora. However, due to the recent release of Fedora 34, version 11 is available. So in this sense we will have no problems.
Install PostgreSQL on Fedora 34
While PostgreSQL is an application, it has many additional libraries to extend its functionality. Or, to make it work with other programming languages such as Java, Python, C++ or PHP. In addition, we can have access to other libraries of the program for development.
So, first of all, I am going to use DNF the Fedora package manager to look for all PostgreSQL related packages.
:~$ sudo dnf search postgresql
As you can see, there are many packages related to PostgreSQL. But as I said before, they refer to libraries needed to extend the functionality.
Now, let’s install it.
:~$ sudo dnf install postgresql-server
Then you have to prepare PostgreSQL for the first use. So, we have to init the database and then, start the service. After that, test it.
:~$ sudo /usr/bin/postgresql-setup --initdb
Next, enable and start the service.
:~$ sudo systemctl enable postgresql Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. :~$ sudo systemctl start postgresql
Now, test the installation.
:~$ sudo su - postgres
And access to the PostgreSQL console.
:~$ psql
Then, list all databases.
:~$ \l
So, PostgreSQL is correctly installed.
Conclusion
PostgreSQL is a great database manager and today you have learned how to install it in Fedora 34. So as you can see it’s quite easy, just share this post with your friends.
