Backup

Pigsty uses pgBackRest to manage PostgreSQL backups, it may be the most powerful open-source backup tools in the ecosystem. With incremental / parallel backup & restore, encryption, MinIO / S3 support, and many other features. Pigsty has pre-configured it for every PGSQL cluster by default.

Policy

Backup scripts, scheduling, pgbackrest, repo and admin

Admin

Backup policy, disk planning, recovery window trade-off

Restore

Restore to specific time point with playbook

Example

Sandbox example: Perform recovery with bare hands

NO WRANTTY

Pigsty try its best to provide a reliable PITR solution, but we do not take any responsibility for the data loss caused by the PITR operation, use it at your own risk. For professional support, consider our pro service.

Quick Start

Backup Policy: Schedule Base Backups with Crontab

WAL Archiving: Continuously record write activities

Restore & Recovery: Recover from backup and wal archive

Full backup everyday 1am

node_crontab: [ '00 01 * * * postgres /pg/bin/pg-backup full' ]

restore to a timepoint