↓ Skip to main content
ProHomeLab – everything about homelab and self-hosting
ProHomeLab – everything about homelab and self-hosting
  1. Categories/

Databases

loading · loading ·
Connecting applications to a shared PostgreSQL and learning basic maintenance. Part 2

Connecting applications to a shared PostgreSQL and learning basic maintenance. Part 2

·1929 words·10 mins· loading · loading
Databases Docker Postgresql Self-Hosting Authentik
The second part of the series on a shared PostgreSQL for a home server. We create a dedicated, minimally privileged user and database in pgAdmin for a specific application, connect Authentik to the shared database instead of its own container, and cover basic maintenance - VACUUM, ANALYZE, REINDEX, and when you actually need to do any of this by hand.