sudo apt update
sudo apt install postgresql postgresql-contrib postgis postgresql-16-postgis-3

sudo -u postgres psql
CREATE USER devuser WITH PASSWORD 'devpass';
CREATE DATABASE myapp OWNER devuser;
\c myapp
CREATE EXTENSION postgis;