The aim of this workshop is to learn creating, managing, and using a spatial database hosted in PostgreSQL server. We will see how to install and connect to PostgreSQL, and then how to create users and databases, install the PostGIS extension, and load data and manage them through QGIS.
PostgreSQL is the most powerful of the open-source databases, used widely in many organisations and with a wealth of training available for free online. Still, it can be daunting to be approached without previous experience. This workshop aims to give a basic introduction of working with spatial data in a PostgreSQL database server by showing the attendants how to install a local PostgreSQL server, connect to it, create and manage users and privileges, and create a spatial database with the PostGIS extension. Then we will move to spatial data and learn how load spatial tables, assign primary and foreign keys, and manage the data both with QGIS and other open-source database management programs. During the workshop, Elisa will also share all the lessons learned in the last 5 years of working with PostgreSQL and the dos and absolutely-don'ts that the attendants need to be aware of (capital letters, anybody?). This workshop is hands-on. **Prerequisite skills:** - Attendees should be familiar with QGIS **Preparation required:** - Own laptop with enough memory and space to install and run - PostgreSQL https://www.postgresql.org/ - QGIS LTR or v3.32+ installed https://www.qgis.org/en/site/ **Book your ticket here:** https://ti.to/osgeo-oceania/foss4g-sotm-oceania-2023-workshops. *A total of 25 spaces are available.*
Speakers: Elisa Puccioni