backup-restore

# Skill: Backup & Restore > **Expertise:** pgBackRest full/WAL/incremental backup, PITR, S3/MinIO storage, CronJob scheduling, CloudNativePG backup CRDs. ## When to load When configuring backup infrastructure, running a restore, verifying backup integrity, or recovering from data loss. ## pgBackRest Configuration ```ini # /etc/pgbackrest/pgbackrest.conf [global] repo1-type=s3 repo1-path=/postgres-backups repo1-s3-bucket=mycompany-db-backups repo1-s3-endpoint=s3.eu-west-1.amazonaws.com repo1-s3-region=eu-west-1 repo1-s3-key=<AWS_ACCESS_KEY> repo1-s3-key-secret=<AWS_SECRET_KEY> repo1-cipher-type=aes-256-cbc repo1-cipher-pass=<STRONG_PASSPHRASE> # rotate annually repo1-retention-full=4 # keep 4 full backups repo1-retention-diff=14 # keep 14 differential backups [global:archive-push] compress-level=3 [production-db] pg1-path=/var/lib/postgresql/data pg1-host=postgres-primary pg1-host-user=postgres ``` ## PostgreSQL: Enable WAL Archiving ```sql -- postgresql.conf (or via ALTER SYSTEM) ALTER SYSTEM SET wal_level = replica; ALTER SYSTEM SET archive_mode = on; ALTER SYSTEM SET archive_command = 'pgbackrest --stanza=production-db archive-push %p'; ALTER SYSTEM SET archive_timeout = '300'; -- archive segment at least every 5 min SELECT pg_reload_conf(); ``` ## Backup Commands ```bash # Initialize stanza (run once) pgbackrest --stanza=production-db stanza-create # Full backup (schedule: weekly) pgbackrest --stanza=production-db --type=fu...