| Property | Value |
|---|---|
| Site | Home |
| Hypervisor host | VE-IO-01 |
| Role | Central PostgreSQL host (Docker) for the Home network. Runs postgres:17.2 exposed on 10.100.100.162:5432 (LAN), the pgAdmin 4 web UI on :8080, and a Portainer agent on :9001 managed by Portainer EE on VM-SL-12. Backing store for the outline database (consumed by the Outline wiki app, frontend VM TBD — P-08) and a currently-empty home default DB. Postgres data lives on the Thunderbolt-attached 512 GB pool mounted at /mnt/data. |
| OS | Debian 12 bookworm (running kernel 6.1.0-28, 6.1.0-44 staged for next boot) |
| Primary IP | 10.100.100.162 |
| SSH alias | vm-sl-62 |
| vCPU | 8 (AMD Ryzen 9 9900X passthrough) |
| Memory | 5.4 GiB |
| Storage | 64 GB ext4 on sda (system /) + 512 GB ext4 on sdb (Thunderbolt-attached pool tb4, mounted /mnt/data — holds Postgres + pgAdmin volumes) |
| Backup | PBS VM-image-level (covers /mnt/data → Postgres + pgAdmin volumes). No logical pg_dump pipeline yet (I-12) — image-only backups are sufficient for crash-consistent restore but a logical dump per database (e.g. nightly pg_dump outline) should be added so individual DBs can be restored without rolling back the whole VM. |
| Mount point | Source | Purpose |
|---|---|---|
/mnt/data |
/dev/sdb (ext4, 512 GB Thunderbolt pool tb4) |
Holds Postgres + pgAdmin data via bind-mounts to /var/lib/docker/volumes/postgres_postgres_data/_data and /var/lib/docker/volumes/postgres_pgadmin_data/_data |
ens18 on bridge Server VLAN 1000 (DHCP-assigned 10.100.100.162/24)BC:24:11:B3:D4:5E| Property | Value |
|---|---|
| SSH user | alexander |
| SSH key (local) | E:/Workspace/Repositories/Clean Up/.secrets/ssh/blackreset_admin_ed25519 |
| Listening ports (notable) | 22 (SSH), 5432 (Postgres LAN), 8080 (pgAdmin LAN), 9001 (portainer-agent) |
| Notes | LAN-only access; no inbound NAT forwards from RZ. Sudo passwordless via /etc/sudoers.d/alexander since 2026-04-29 onboarding. |
/etc/apt/sources.list was silently corrupted (HTML-encoded > chars truncating bookworm-security repo) — security updates had not been applied for months. Repaired during cleanup; 102 packages incl. kernel + openssh upgraded.migration/2026-05-03-night-recovery) over the site-to-site VPN — Home loses name resolution if VPN drops. VM-DC-02 retired, so this is currently unavoidable. Old plan was: flip to VM_DC_02 (10.100.100.101) planned site-wide.:latest — pin to major.minor for reproducibility.:latest tag — see I-05./ as /host — privileged control surface; documented trade-off for remote management from VM-SL-12.outline DB on this serverOutline-DB liegt aktuell hier; perspektivisch zieht die DB auf vm-hm-db-01 um (target-architecture-2026 §5). Bis dahin bleibt Page als historisch-relevant.