GIS tutorial

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

Required for this tutorial:
– account DigitalOcean (REFERRAL LINK
– 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
– (
– sudo apt update
– sudo apt install postgresql postgresql-contrib
– (
– (
– sudo apt-get install postgresql-10-postgis-2.4
– (
– 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