Commands.app

pg_dumpall

Backup & Restore

Backup all PostgreSQL databases

Options & Flags
Available options for this command
--globals-only

Dump only global objects (roles, tablespaces)

--roles-only

Dump only roles

Examples
Common usage examples

Backup all databases

pg_dumpall > all_databases.sql

Backup only roles and tablespaces

pg_dumpall --globals-only > globals.sql
Notes
  • Output is always plain SQL format
  • Includes all databases, roles, and tablespaces
Related Commands
You might also find these useful
pg_dumppg_restore