How to install PostgreSQL on Ubuntu 19.04?

Windows Articles

Learn how to control the volume of Windows using the mouse wheel.

Hi! Windows recently celebrated its 35th anniversary. Therefore, it is one of the longest lasting and most used systems currently. On the other hand,...

Install Nim programming language on Ubuntu 20.04 / Debian 10

Nowadays, almost everything is done with the help of a computer and a program. And the programs are made through a programming language. That...

Configure Samba File share Services with Ubuntu 20.04 LTS

Here, Today! let's discuss samba file share service with Ubuntu 20.04 LTS. If you need to share files between Linux and MS Windows...

Install Matomo on Ubuntu 20.04

Hello, friends. In this post, you will learn how to install Matomo on Ubuntu 20.04. It's quite useful to measure the traffic to our...

How to change DNS in Windows 10

Hi! Today we will talk a bit about networks. In fact, we will touch on a topic related to connectivity. Specifically we will see...
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

Learn how to control the volume of Windows using the mouse wheel.

Hi! Windows recently celebrated its 35th anniversary. Therefore, it is one of the longest lasting and most used systems currently. On the other hand,...

Install Nim programming language on Ubuntu 20.04 / Debian 10

Nowadays, almost everything is done with the help of a computer and a program. And the programs are made through a programming language. That...

Configure Samba File share Services with Ubuntu 20.04 LTS

Here, Today! let's discuss samba file share service with Ubuntu 20.04 LTS. If you need to share files between Linux and MS Windows...

Install Matomo on Ubuntu 20.04

Hello, friends. In this post, you will learn how to install Matomo on Ubuntu 20.04. It's quite useful to measure the traffic to our...

How to change DNS in Windows 10

Hi! Today we will talk a bit about networks. In fact, we will touch on a topic related to connectivity. Specifically we will see...
x