📝 Juan Gallego IV's Notes

PostgreSQL: dump & restore data on Docker

Tags: #docker #postgresql

Dumping and restoring a PostgreSQL database. Replace postgres with PostgreSQL's service name.

Dump

docker exec -t postgres pg_dumpall -c -U postgres > dump.sql

Restore

cat dump.sql | docker exec -i postgres psql -U postgres