Backup and restore dockerised postgres database

backup_restore_postgres.sh

# Backup
docker exec -t your-db-container pg_dumpall -c -U postgres > dump_$(date +"%Y-%m-%dT%H-%M-%S").sql

# Backup gzipped
docker exec -t your-db-container pg_dumpall -c -U postgres | gzip > ./tmp/dump_$(date +"%Y-%m-%dT%H-%M-%S").gz

# -------------------------------------------------------------------------------------------------------------

# Restore
cat your_dump.sql | docker exec -i your-db-container psql -U postgres

# Restore gzipped
gzip -d ./tmp/dump_{DATE} | cat your_dump.sql | docker exec -i your-db-container psql -U postgres