postgres-adminlisted
Install: claude install-skill tgunawandev/kodemeio-platform
# PostgreSQL Administration for Kodemeio
## System Overview
- **PostgreSQL 16.12** at `db.kodeme.io` (Hetzner private network `10.0.0.3`)
- **PostGIS 3.5** (Alpine-based custom Docker image)
- **PgBouncer** for transaction-level connection pooling (port 6432)
- **postgres-exporter** for Prometheus metrics (port 9187)
- **Deployed**: Dokploy on `dokploy.kodeme.io` with `dokploy-network`
- **SSH access**: `root@db.kodeme.io` (public IP: 49.13.14.79)
- **Connection**: SSH tunnel -> Docker port mapping -> PostgreSQL container
## Production Databases
| Database | Owner | Size | Purpose |
|---|---|---|---|
| authentik | authentik | 87 MB | Identity provider (auth.kodeme.io) |
| zulip | zulip | 58 MB | Team chat (zulip.kodeme.io) |
| glitchtip | glitchtip | 53 MB | Error tracking (glitchtip.kodeme.io) |
| hmdm | hmdm | 50 MB | Mobile device management |
| outline | outline | 49 MB | Wiki/docs (outline.kodeme.io) |
| gatus | gatus | 48 MB | Uptime monitoring (gatus.kodeme.io) |
| plane | plane | 23 MB | Project management (plane.kodeme.io) |
| postgres | postgres | 16 MB | Default/admin database |
## Production Roles
| Role | Flags | Purpose |
|---|---|---|
| postgres | SLCRP | Superuser (admin) |
| app | L | Generic application user |
| authentik | L | Authentik service (conn limit: 50) |
| zulip | L | Zulip service |
| outline | L | Outline service |
| gatus | L | Gatus service |
| glitchtip | L | GlitchTip service |
| hmdm | L | Headwind MDM service |
| plane | L | Plane ser