How to Install Postgres on Ubuntu 20.04

This post is a short note on how to install Postgres on Ubuntu 20.04.

I’m doing this in WSL, however this shouldn’t make any difference if you’re on the same Ubuntu version.

First, lets update our local packages by running the following apt command –

# update local packages
sudo apt update

This Postgres installation is very quick and simple.

The following command is also including the ‘-contrib‘ package which gives us extra functionalities.

# install postgres on ubuntu
sudo apt install postgresql postgresql-contrib

Once the installation completes, we can enter psql using the postgres user created automatically during the install.

# login to psql with the out of box postgres user
sudo -u postgres psql

\q (to quit back to terminal)

There may be a need to restart the services post install which can be done by running the following.

# restart postgres service ubuntu
sudo service postgresql restart