What is the command to export PostgreSQL from Docker?

Use docker exec -i [container] pg_dump -U postgres [db] > dump.sql. Add -e PGPASSWORD for auth.

How do I restore a pg_dump from Docker Postgres?

psql -U postgres -d [db] < dump.sql. For gzipped, gunzip first.

Yes — compress with | gzip > dump.sql.gz, or use -Fc for custom format and parallel restores.

🗄️ Databases & Backend

Yes — compress with | gzip > dump.sql.gz, or use -Fc for custom format and parallel restores.

こんな場面だ：Postgresコンテナがデータをガンガン回してる最中、デプロイで全部ぶっ飛ばされそう。1コマンドでデスクトップに完全dump.sqlがポン。シンプル？ああ。コンテナ狂乱の今、必須？当然だ。

DevTools Feed Apr 07, 2026 1 min read

Read in: Deutsch English Français 日本語

Published by

Ship faster. Build smarter.

#Docker #PostgreSQL #database-backup #pg_dump

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

Originally reported by dev.to