Cheat Sheet logoCheat Sheet Today
PostgreSQL Backup and Restore Cheat Sheet/Physical base backup

Take a physical base backup suitable for replication or disaster recovery.

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

Physical base backup

bash
bash
pg_basebackup -h primary-db -U replicator -D /backups/base -Fp -Xs -P
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
Dump entire cluster
Dump all databases in one plain SQL file.
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