PostgreSQL Setup

Creating a local database (Ubuntu 22.04)

Install PostgreSQL server and PostGIS extension:

sudo apt install postgresql postgis

Add a user john and create a database for the user:

sudo -u postgres createuser john
sudo -u postgres psql -c "CREATE DATABASE survey OWNER john"
sudo -u postgres psql -d survey -c "CREATE EXTENSION postgis;"