| Property | Value |
|---|---|
| Host VM | VM-SL-62 |
| Compose path | /opt/postgres/docker-compose.yml |
| Image | postgres:17.2 |
| Container name(s) | postgres |
| External URL | <— (DB endpoint, no UI; admin via pgAdmin (Home))> |
| Networks | Host port 5432 published on 10.100.100.162 (LAN). Internal Docker network shared with pgadmin. |
| DB / state | /mnt/data/postgres_data (bind-mount on Thunderbolt-attached sdb pool tb4) |
| Auth | POSTGRES_USER=root / password (env-supplied) — non-default superuser name; consumer services use per-DB owners. |
| Backup | PBS VM-image-level via VM-SL-62 (covers /mnt/data). No logical pg_dump pipeline today (I-12) — schedule a nightly per-DB logical dump so individual databases can be restored without rolling back the entire VM image. |
Single shared Postgres engine on the Home network. Hosts the outline database for the Outline wiki (frontend VM TBD — P-08) and a currently-empty default home database. Lives on the Thunderbolt-attached pool so VM-SL-62 itself stays small and the data tier can be moved/expanded independently.
postgres:17.2 (Docker)root (POSTGRES_USER override; not the default postgres)/mnt/data/postgres_data (bind-mount)home — owner root, currently empty default DBoutline — owner outline, consumed by Outline wiki app (P-08)Port 5432/tcp on LAN (10.100.100.162). No TLS on the connection — consider restricting to 127.0.0.1 + reverse-proxy, or enable TLS (I-11).
Password via POSTGRES_PASSWORD env. Per-DB owners (outline) used for app connections; root reserved for admin.
/mnt/data/postgres_data — Postgres data dir (bind-mount on tb4 pool)docker compose -f /opt/postgres/docker-compose.yml psdocker logs postgresdocker exec -it postgres psql -U rootdocker exec postgres pg_dump -U root outline > outline-$(date +%F).sql:latest style (postgres:17.2 is a major.minor pin which is OK; verify the compose file actually uses it and not postgres:latest).dpage/pgadmin4:latest — see pgAdmin (Home).pg_dump pipeline yet — only PBS image-level backup exists.Per migration/target-architecture-2026 §5 zieht der Home-Postgres auf vm-hm-db-01 (10.100.100.111) um. Aktuell ist vm-sl-62 der legacy-Host (nur die outline-DB liegt noch dort). Ziel: konsolidierte DB auf hm-db-01 — siehe /vms/vm-hm-db-01.