PostgreSQL
PostgreSQL usage on sepia.
Instances
| Instance | Type | Port | Data Dir | Used By |
|---|---|---|---|---|
| DSMR DB | PostgreSQL 17.9 | 5432 | /opt/dsmr/data/ |
DSMR Reader |
| TimescaleDB | TimescaleDB 2.7.1-pg14 | 6543 | /media/scratch/timescaledb/ |
Time-series |
Connection
DSMR (port 5432)
psql -h localhost -p 5432 -U dsmrreader dsmrreader
Password from ${DSMRDB_PASSWORD} in .env.
TimescaleDB (port 6543)
psql -h localhost -p 6543 -U timescaleuser
Password: timescalepwd (hardcoded in compose file).
Maintenance
Vacuum
docker exec dsmrdb psql -U dsmrreader -c "VACUUM ANALYZE;"
Backup DSMR DB
docker exec dsmrdb pg_dump -U dsmrreader dsmrreader > /opt/dsmr/backups/dsmr_$(date +%Y%m%d).sql