How to install PostgreSQL on Fedora 30?

0
59

We are celebrating the launch of Fedora 30. 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 30.

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 30, version 11 is available. So in this sense we will have no problems.

Install PostgreSQL on Fedora 30

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
1.- Using dnf for search PostgreSQL
1.- Using dnf for 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
2.- Install PostgreSQL on Fedora 30
2.- Install PostgreSQL on Fedora 30

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
3.- Init the sample database
3.- Initialize the sample database

Next, enable and start the service.

:~$ sudo systemctl enable postgresql
:~$ sudo systemctl start postgresql

Now, test the installation.

:~$ sudo su - postgres

And access to the PostgreSQL console.

:~$ psql

Then, list all databases.

:~$ \l
4.- PostgreSQL is correctly installed
4.- PostgreSQL is correctly installed

So, PostgreSQL is correctly installed.

Conclusion

PostgreSQL is a great database manager and today you have learned how to install it in Fedora 30. So as you can see it’s quite easy, just share this post with your friends.

LEAVE A REPLY

Please enter your comment!
Please enter your name here