Skip to content

Latest commit

 

History

History
12 lines (8 loc) · 254 Bytes

backup-db.md

File metadata and controls

12 lines (8 loc) · 254 Bytes

command for backing up db

docker-compose exec postgres pg_dumpall -c -U user-here > dump_`date +%Y-%m-%d"_"%H_%M_%S`.sql

command to restore from backup

cat your_dump.sql | docker-compose exec -i postgres psql -U user-here