Manages and automates PostgreSQL backup and recovery operations using pgBackRest and Wasabi S3 storage.
The FairDB Backup Manager is a comprehensive skill designed to handle all aspects of database protection for PostgreSQL environments. It automates complex pgBackRest configurations, manages scheduled backups (full, differential, and incremental), and ensures data durability through Wasabi S3 integration. By enforcing best practices like AES-256 encryption and regular test restores, it provides developers with a robust disaster recovery framework that includes point-in-time recovery (PITR) and proactive health monitoring to prevent data loss.
Key Features
01Comprehensive backup scheduling including full, differential, and incremental types
02Automated pgBackRest configuration with Wasabi S3 integration
03AES-256 encryption and secure key management enforcement
04Point-in-time recovery (PITR) for granular data restoration
05Proactive monitoring and automated alerting for backup failures
06883 GitHub stars
Use Cases
01Automating backup strategies for new multi-tenant database deployments
02Generating compliance reports and monitoring storage costs for database infrastructure
03Recovering production data to a specific timestamp after accidental data loss
