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
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
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
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
after sudo -i -u postgres i got the following .
:~$ sudo -i -u postgres
postgres is not in the sudoers file. This incident will be reported.
:~$
sudo apt install postgresql-11
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
postgresql-11 : Depends: libicu60 (>= 60.1-1~) but it is not installable
E: Unable to correct problems, you have held broken packages.
Thanks for your article. Very helpful.
Thanks. Do no to forget to share the post to help many people more.