Cheat Sheet logoCheat Sheet Today
PostgreSQL Backup and Restore Cheat Sheet/Dump entire cluster

Dump all databases in one plain SQL file.

Back to sheetBrowse commands
Sign in to save
Section: Cluster-wide Backup and Migration

Dump entire cluster

bash
bash
pg_dumpall -h localhost -U postgres > cluster.sql
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Cluster-wide Backup and Migration
Dump global objects
Export cluster-wide roles and tablespaces.
OpenIn sheetbashsame section
Physical base backup
Take a physical base backup suitable for replication or disaster recovery.
OpenIn sheetbashsame section
Verify base backup
Verify integrity of a base backup manifest.
OpenIn sheetbashsame section
Run pg_upgrade check
Check whether an in-place major upgrade is feasible.
OpenIn sheetbashsame section
Run pg_upgrade
Perform an in-place major version upgrade.
OpenIn sheetbashsame section
Analyze upgraded cluster
Collect statistics after a fresh restore or upgrade.
OpenIn sheetbashsame section