Cheat Sheet logoCheat Sheet Today
PostgreSQL Backup and Restore Cheat Sheet/Dump global objects

Export cluster-wide roles and tablespaces.

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

Dump global objects

bash
bash
pg_dumpall -h localhost -U postgres --globals-only > globals.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 entire cluster
Dump all databases in one plain SQL file.
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