DB creation 🐘 PostGIS in cloud for QGIS in 10 minutes (DigitalOcean + Postgres)

Required for this tutorial:
– account DigitalOcean (REFERRAL LINK https://m.do.co/c/0b88c63ccdf0)
– PuTTY: a free SSH and Telnet client
– Windows 8 or higher
– pgAdmin4

Italian version: this link

Video tutorial


– create droplet digitalocean 1GB 5€/mo
– connect with putty and change password
– (https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04)
– sudo apt update
– sudo apt install postgresql postgresql-contrib
– (https://black-tea.github.io/setup-notes/2017/03/12/Postgres-and-GeoServer-on-DigitalOcean-Ubuntu.html)
– (https://launchpad.net/ubuntu/bionic/+package/postgresql-10-postgis-2.4)
– sudo apt-get install postgresql-10-postgis-2.4
– (https://www.igismap.com/install-postgis-postgresql-ubuntu/)
– sudo -u postgres psql
postgres=# CREATE DATABASE mygeo;\connect mygeo;
postgres=# CREATE EXTENSION postgis SCHEMA public; (QGIS expects postGIS to be installed in Public schema)
postgres=# create user pjhooker with encrypted password ‘1jRM6EA0’;
postgres=# grant all privileges on database mygeo to pjhooker;
– putty tunnel
– create connection with pgadmi4
– create connection with qgis3.2
– import pg_cittametropolitane
– load in qgis pg_cittametropolitane