# BACKUP
docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/db.sql

# RESTORE
cat db.sql | docker exec -i <container-name> psql -U <user> <db-name>