FOSS4G NA 2024

Postgres and PostGIS Ops Management
09-10, 11:30–12:00 (America/Chicago), Grand B

PostGIS forms the backbone of many open-source geospatial projects. I’ll help you get started with managing Postgres outside of your local machine. We’ll cover hosting, sizing, tuning, backups, connections, and basic performance topics to get you started.


Topics covered (in brief):
Postgres hosting options: self-hosted, cloud, Kubernetes, local options
Fully managed choices and self managed
Storage & backups, backup files vs backup systems
Postgres memory, sizing and tuning
How I/O works
Roles and role groups
Connections for applications
Introduce indexes
Monitoring options