PostgreSQL postgis

Example for Ubuntu and osmdb

apt install postgis
psql -d xxx //xxx=any dbname of a db one can connect to
CREATE DATABASE osmdb;
\c osmdb;
CREATE EXTENSION postgis;