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

Postgresql

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.