| Feld |
Wert |
| Site |
RZ (Hetzner ESXi) |
| Hypervisor host |
ESXi-RZ |
| Rolle |
Zentrale RZ-Datenbank-VM — Postgres 17.6 + MariaDB als Container |
| OS |
Debian 12.x |
| Primary IP |
10.100.0.111 (VLAN 100 DB) |
| DNS-intern |
vm-rz-db-01.rz.blackreset.internal |
| Compose-Root |
/opt/{postgres,mariadb}/ |
| Last-changed |
2026-05-04 |
| Stack |
Image |
Port |
Use |
pg-app |
postgres:17.6 (via Harbor) |
5432 |
Zentrale Postgres-Instanz |
mariadb-app |
mariadb:11.8 (via Harbor) |
3306 |
MariaDB-Container für Apps die noch MariaDB brauchen |
¶ Postgres DBs (10 user-DBs Stand 2026-05-04)
| DB |
Konsument |
Erstellt |
authentik |
Authentik (vm-rz-svc-prod-01) |
2026-05-01 |
wikijs |
Wiki.js (vm-rz-svc-prod-01) |
2026-05-01 |
gitlabhq_production |
GitLab CE (vm-rz-svc-prod-01) |
2026-05-01 |
nextcloud |
Nextcloud (vm-rz-svc-prod-01) |
2026-05-03 (db:convert-type von MySQL) |
vaultwarden |
(geplant) Vaultwarden |
— |
azuracast, privatebin |
AzuraCast / PrivateBin (vm-rz-app-prod-01) |
2026-05-02 |
org_stack, org_metadata |
Organization-Stack |
2026-05-02 |
wikijs_metadata |
Wiki-Metadata |
2026-05-01 |
NextXID Stand 2026-05-03: 0:198511 (siehe state_pg_recovery_2026-05-03 — false-alarm-recovery).
22 DBs aus vm-db-01 migriert 2026-05-02 (siehe migration/2026-05-02-overnight-summary). Pterodactyl-Repoint pending (vm-sl-09 .env DB_HOST → 10.100.0.111).
- VLAN: 100 (DB) — direkt erreichbar von SVC (200) und APP (200/210).
- Firewall: Inbound 5432 + 3306 nur aus 100/200/210; kein public expose.
/opt/postgres/data/ — PG-Datadir (bind-mount)/opt/mariadb/data/ — MariaDB-Datadir/opt/postgres/wal-archive/ — WAL für PITR (geplant via Databasement)
- Hard-Dep für: Authentik, Wiki, GitLab, NC, AzuraCast, PrivateBin, organization-stack, AzuraCast-DB, etc.
- Wird von Databasement (vm-hm-backup-01) gepullt für GFS-Backups.
- VM-Image via PBS (vm-pb-02 + vm-hm-backup-01).
- DB-Dumps via Databasement (täglich + WAL-stream geplant).
- Disaster-Recovery-Test stand: 2026-05-03 false-alarm (Container war nur gestoppt, kein Datenverlust).
- 2026-05-01 — Phase 5 deploy (PG 17.6 fresh init).
- 2026-05-02 — MariaDB-Container hinzugefügt + 22 DBs aus vm-db-01 migriert.
- 2026-05-03 — false-alarm Disaster-Recovery (siehe
state_pg_recovery_2026-05-03).
- 2026-05-04 — Wiki-Cleanup: Successor-Page für
services/postgres-production.
- Successor von: vm-db-01 (native MariaDB, decom 2026-05-02),
services/postgres-production (Container, decom 2026-05-02).