Loading...
Loading...
PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR
npx skill4agent add pluginagentmarketplace/custom-plugin-postgresql postgresql-backupAtomic skill for backup and recovery
parameters:
backup_type:
type: string
required: true
enum: [logical, physical, pitr]
format:
type: string
enum: [custom, directory, plain]
default: custom# Custom format (recommended)
pg_dump -Fc -f backup.dump dbname
# Parallel backup
pg_dump -Fd -j 4 -f backup_dir dbname
# Compressed
pg_dump -Fc dbname | gzip > backup.dump.gzpg_basebackup -D /backup -Fp -Xs -P -Rpg_restore -d newdb -j 4 backup.dump
pg_restore --list backup.dump # Previewarchive_mode = on
archive_command = 'cp %p /archive/%f'| Type | Use Case | Recovery Speed |
|---|---|---|
| pg_dump | Logical, portable | Slow |
| pg_basebackup | Full cluster | Fast |
| WAL + base | Point-in-time | Fast + precise |
| Problem | Cause | Solution |
|---|---|---|
| Backup failed | Disk full | Free space |
| Restore slow | Large DB | Use parallel |
| WAL missing | Archive failed | Check archive_command |
Skill("postgresql-backup")