How to install PostgreSQL on Ubuntu 19.04?

0
59

On many occasions, it is necessary to install various software to increase the power of the operating system. Even though Linux is one of the most popular alternatives in the field of development, it is also necessary to install some programs. However, Ubuntu’s package repositories are one of the largest of Linux and that brings with it multiple advantages when installing applications. Many of these applications are really important on a server as a database manager. So in this post, we will show you how to install PostgreSQL on Ubuntu 19.04. Therefore, you can enjoy this great database manager on your computer.

PostgreSQL is one of the consents as far as database managers are concerned. It is an open source and community solution to very large database problems. This is because PostgreSQL is very efficient in managing resources. In addition, PostgreSQL has been developed over many years, so the experience the software has is enviable.

Likewise, PostgreSQL has become one of the most reliable database managers out there, making it a formidable alternative to MariaDB.

Finally, it is good to say that PostgreSQL has a very good official documentation so you can learn everything about it.

So, let us start to install PostgreSQL on Ubuntu 19.04.

Getting PostgreSQL on Ubuntu 19.04

As I said before, PostgreSQL is in the official repositories of the distribution. So installing it is simple. However, it is also good to work with the service.

Then, open a terminal emulator and run the following command:

:~$ sudo apt install postgresql-11
1.- Install PostgreSQL on Ubuntu 19.04
1.- Install PostgreSQL on Ubuntu 19.04

After the installation is finished, Ubuntu will start the PostgreSQL service. It will also configure the service to start automatically. So we still have to verify the status of the service.

:~$ sudo systemctl status postgresql
2.- Service status
2.- Service status

Now, to check that the installation has been successful we will access the PostgreSQL console. With this, we will know that it is ready for work.

:~$ sudo -i -u postgres
:~# psql

Next, list all the databases:

:~# \l
3.- List all databases
3.- List all databases

So, that’s it.

Conclusion

Now you know how to install PostgreSQL in Ubuntu 19.04 and you can take full advantage of this database manager. AdeƱas, Ubuntu is a great Linux distribution that allows us to use PostgreSQL in a very reliable way.

So, share this post with your friends

LEAVE A REPLY

Please enter your comment!
Please enter your name here