node_crontab

[jinliang-qi]

Hello, may I ask how to set up my backup to be kept for one month before deletion?
node_crontab: #

• '00 01 * * 1 postgres /pg/bin/pg-backup full'
• '00 01 * * 2,3,4,5,6,7 postgres /pg/bin/pg-backup'

./node.yml -t node_crontab -l pg-meta

[Vonng]

Hi, the crontab schedule only controls when backups are taken — it does not control how long they are kept. Backup retention is managed by the pgbackrest_repo parameter.

By default, Pigsty keeps backups by count (retention_full_type: count, retention_full: 2). To keep backups for one month, switch to time-based retention:

pgbackrest_repo:
  local:
    path: /pg/backup
    retention_full_type: time    # retain by time instead of count
    retention_full: 30           # keep backups for 30 days

Also, a couple of notes on your crontab config:

1. In recent Pigsty versions, use pg_crontab instead of node_crontab for postgres-user cron jobs — entries do not include the username field:

pg_crontab:
  - '00 01 * * 1 /pg/bin/pg-backup full'       # Monday full backup
  - '00 01 * * 2,3,4,5,6,7 /pg/bin/pg-backup'   # Other days incremental

2. Apply with the pgsql playbook, not node:

./pgsql.yml -l pg-meta -t pg_crontab

Make sure your backup disk has enough capacity for ~5 full backups + 30 days of WAL archives.

Relevant docs:

• Backup & PITR: https://pigsty.io/docs/pgsql/pitr/
• Cron Jobs: https://pigsty.io/docs/pgsql/admin/crontab/
• Parameters (pgbackrest_repo): https://pigsty.io/docs/pgsql/param/