Tutorial

This article is a very short tutorial for installing PostgreSQL 12/ PostGIS on the Ubuntu system. It is a production note which I initially wrote for myself to install PostgreSQL on several machines. The explanation is kept very short and straight to the result.

Step 1: Add and Install the PostgreSQL 12 via your terminal.

$ sudo apt update
$ sudo apt install postgresql-12 postgresql-client-12

Step 2: Test PostgreSQL + Assign password to postgres

$ systemctl status postgresql.service

Then, connect and change the “postgres” password.

$ sudo -u postgres psql
$ \password postgres
enter strong password twice!

Step 3: Install GnuPG 2.0 and PostGIS

$ sudo sudo apt install gnupg2
$ sudo apt install postgis postgresql-12-postgis-3

Step 4: Set the Client Authentication & Connection

# ========================================
# === Set Listening Port =================
# ========================================
$ nano /etc/postgresql/12/main/postgresql.conf
# listen_addresses = '*' ==> Listen on all interfaces  
# listen_addresses = '<ip here>'==> Listen on specified IP address# ========================================
# === Set Client authentication ==========
# ========================================
$ nano /etc/postgresql/12/main/pg_hba.conf
# TYPE  DATABASE     USER       ADDRESS                 METHOD
# host  postgres     all        192.168.12.10/32        md5

Step 5: Connect and enjoy PostgreSQL via your favorite GUI!