Creazione DB 🐘 PostGIS in cloud per QGIS in 10 minuti (DigitalOcean + Postgres)

Blog

Creazione DB 🐘 PostGIS in cloud per QGIS in 10 minuti (DigitalOcean + Postgres)

Creazione DB 🐘 PostGIS in cloud per QGIS in 10 minuti (DigitalOcean + Postgres) >>

Per info gistips WhatsApp 3487448152 email lima.cityplanner@gmail.com
Richiesto per il tutorial:
- account DigitalOcean (REFERRAL LINK https://m.do.co/c/0b88c63ccdf0)
- PuTTY: a free SSH and Telnet client
- Windows 8 or higher
- pgAdmin4
- QGIS

Versione in inglese: questo link

Procedura

- 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)
(https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e)
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