What is the exact command to export PostgreSQL database from Docker?

One line: `docker exec -i postgres_container pg_dump -U postgres my_database > dump.sql`. Swap names/passwords as needed.

How do you restore a pg_dump file to Docker Postgres ?

`docker exec -i postgres_container psql -U postgres -d my_database < dump.sql`. Create DB first if empty.

Yes—pipe to gzip for compression. Use `--jobs=4` for parallel speed on big ones.

🗄️ Databases & Backend

Yes—pipe to gzip for compression. Use `--jobs=4` for parallel speed on big ones.

Docker turned databases into container puzzles. Here's the dead-simple pg_dump fix that actually works—every time.

theAIcatchup Apr 08, 2026 4 min read

Published by

Ship faster. Build smarter.

#Docker #PostgreSQL #database-backup #docker postgres #export postgresql #pg_dump

Get the best Developer Tools stories of the week in your inbox — no noise, no spam.

Originally reported by dev.to