How to install PostgreSQL on Ubuntu 19.04?

Windows Articles

How to install Lighttpd on Ubuntu 20.04?

There are many web services in Unix but we always look for the one that best suits our needs. In this case,...

How to install Docker on Ubuntu 20.04 / Debian 10?

Docker is a fairly popular technology in today's sysadmin. It is logical to think because it means a complete change in the way images...

How to install Mantis Bug Tracker on Ubuntu 20.04?

Hi, folks. In this post, I will help you to install Mantis Bug Tracker on Ubuntu 20.04 If you...

How to install WordPress with Nginx on Ubuntu 20.04?

Hi, folks. In this post, we will help you install Wordpress with Nginx on Ubuntu 20.04. It's a lot easier than you...

Electron 9.0 available

News has arrived that many developers are going to love. And that is that Electron this great cross-platform application framework has released...
angeloma
angeloma
Senior Writer and partner

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

More articles

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

How to install Lighttpd on Ubuntu 20.04?

There are many web services in Unix but we always look for the one that best suits our needs. In this case,...

How to install Docker on Ubuntu 20.04 / Debian 10?

Docker is a fairly popular technology in today's sysadmin. It is logical to think because it means a complete change in the way images...

How to install Mantis Bug Tracker on Ubuntu 20.04?

Hi, folks. In this post, I will help you to install Mantis Bug Tracker on Ubuntu 20.04 If you...

How to install WordPress with Nginx on Ubuntu 20.04?

Hi, folks. In this post, we will help you install Wordpress with Nginx on Ubuntu 20.04. It's a lot easier than you...

Electron 9.0 available

News has arrived that many developers are going to love. And that is that Electron this great cross-platform application framework has released...