Skip to content

Latest commit

 

History

History
14 lines (11 loc) · 309 Bytes

DB.md

File metadata and controls

14 lines (11 loc) · 309 Bytes

Backup

docker compose exec postgresql pg_dumpall -c --if-exists -U postgres | gzip > dump.sql.gz

Restore

gunzip dump.sql.gz
docker compose exec -T postgresql psql -U postgres < dump.sql
docker compose exec postgresql psql -U postgres
> ALTER USER postgres WITH PASSWORD 'password';