CT320 — Shared Postgres

CT320 hosts a shared PostgreSQL 16 instance for Helsinki2 services that do not use their own local database container.

Container

Property	Value
CTID	320
Hostname	pg-ct
IP	192.168.100.70
Postgres	16
Port	5432

Databases

Database	Owner	Consumer
twenty_lifehouse	twenty_lifehouse_app	Lifehouse Twenty CRM
matomo	matomo	Matomo Analytics

Isolation Rule

EchoHuman Twenty CRM does NOT use CT320. It uses its own local echohuman-twenty-db-1 Postgres container on VM700.

Connecting

# From Proxmox host or any internal node
psql -h 192.168.100.70 -U <user> -d <database>

# Inside CT320
pct exec 320 -- psql -U postgres

Adding a Database

pct exec 320 -- psql -U postgres << 'SQL'
CREATE USER newapp WITH PASSWORD 'secret';
CREATE DATABASE newapp OWNER newapp;
GRANT ALL PRIVILEGES ON DATABASE newapp TO newapp;
SQL

Backup

pct exec 320 -- pg_dumpall -U postgres > /tmp/pg_backup_$(date +%Y%m%d).sql