6 C
Texas
angeloma
Senior Writer and partner

How to install PostgreSQL on Ubuntu 19.04?

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.

- Advertisement -

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

- Advertisement -
Everything Linux, A.I, IT News, DataOps, Open Source and more delivered right to you.
Subscribe
"The best Linux newsletter on the web"

4 COMMENTS

  1. 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.
    :~$

  2. 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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here



Latest article