How to export PostgreSQL database from Docker container?

One command: `docker exec -i your_container pg_dump -U postgres your_db > backup.sql`. Handles passwords via PGPASSWORD env.

What if pg_dump needs a password in Docker?

Prefix with `-e PGPASSWORD='pass'`: full command pipes securely.

Yes — `... | gzip > dump.sql.gz`. Shrinks huge DBs instantly.

☁️ Cloud & Databases

Your Postgres data in Docker? One command sets it free. Here's the pg_dump magic that turns container chaos into clean backups.

theAIcatchup Apr 08, 2026 3 min read

Published by

Community-driven. Code-first.

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

Get the best Open Source stories of the week in your inbox — no noise, no spam.

Originally reported by Dev.to