CmdID

CmdID / Commands

pg_basebackup

Take a base backup of a running PostgreSQL cluster. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Take a base backup of a running PostgreSQL cluster. Used for full or incremental backups, point-in-time recovery, or setting up replication standbys.

Take a base backup from a remote PostgreSQL server

pg_basebackup --host host --pgdata path/to/backup_dirIdentify

Take a backup with progress shown

pg_basebackup --host host --pgdata path/to/backup_dir --progressIdentify

Create a compressed backup (gzip) in tar format

pg_basebackup --pgdata path/to/backup_dir --format [t --gzipIdentify

Create an incremental backup using a previous manifest file

pg_basebackup --pgdata path/to/backup_dir --incremental path/to/old_manifestIdentify

Write a recovery configuration for setting up a standby

pg_basebackup --pgdata path/to/backup_dir --write-recovery-confIdentify

Relocate a tablespace during backup

pg_basebackup --pgdata path/to/backup_dir --tablespace-mapping path/to/old_tablespace=path/to/new_tablespaceIdentify

Limit transfer rate to reduce server load

pg_basebackup --pgdata path/to/backup_dir --max-rate 100MIdentify

Stream WAL logs while taking the backup

pg_basebackup --pgdata path/to/backup_dir --wal-method streamIdentify