Docker Backup, Restore PostgreSQL Database

Single Database

PostgreSQL Backup Single Database

sudo docker exec -t --user pg_username pg_container_name pg_dump -c -p 5432 -U pg_username "database_name" > "/path/on/your/machine/dump.sql"

PostgreSQL Restore Single Database

sudo docker exec -t --user pg_username pg_container_name psql -c -p 5432 -U pg_username -d "database_name" -f "/path/on/your/machine/dump.sql"

All Databases

PostgreSQL Backup All Database

sudo docker exec -t --user pg_username pg_container_name pg_dumpall -c -U pg_username > "/path/on/your/machine/dump.sql"

PostgreSQL Restore All Database

sudo cat dump.sql | sudo docker exec -i --user pg_username pg_container_name psql

References

https://dothanhlong.org/note-lenh-backup-postgresql-database-with-password/