Would you like to learn how to install a PostgreSQL server on Ubuntu Linux? In this tutorial, we are going to show you all the steps required to install and configure PostgreSQL on UbuntuLinux.

• Ubuntu 19.10

PostgreSQL Related Tutorial:

On this page, we offer quick access to a list of tutorials related to PostgreSQL.

Tutorial - PostgreSQL install on Ubuntu Linux

On the Linux console, use the following commands to check your Ubuntu codename.

Copy to Clipboard

In our example, Ubuntu 19.10 codename is eoan.

Take note of this information.

On the Linux console, use the following commands to add the PostgreSQL APT repository

Copy to Clipboard

Install the PostgreSQL package.

Copy to Clipboard

Restart the PostgreSQL service.

Copy to Clipboard

Verify the PostgreSQL service status.

Copy to Clipboard

Here is the command output:

Copy to Clipboard

Use the following commands to access the PostgreSQL service command-line interface.

Copy to Clipboard

Use the following PostgreSQL command to list all databases on your server.

Copy to Clipboard

Here is the command output.

Copy to Clipboard

Use the following command to exit the PostgreSQL command-line interface.

Copy to Clipboard

Congratulations! You have installed the PostgreSQL service successfully.