fairdb-backup-manager

Community

Automate PostgreSQL backups for FairDB with pgBackRest.

Authorjeremylongshore
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill automatically handles all backup-related operations for FairDB PostgreSQL databases, including scheduling, verification, restoration, and monitoring of pgBackRest backups with Wasabi S3 storage. It ensures data protection, compliance, and rapid recovery for critical database systems.

Core Features & Use Cases

  • Comprehensive Backup Operations: Configure pgBackRest, execute full/differential/incremental backups, and manage schedules.
  • Point-in-Time Recovery (PITR): Perform precise data restoration to any specific timestamp.
  • Proactive Monitoring & Verification: Check backup status, verify integrity, and alert on failures.
  • Use Case: Onboard a new customer by automatically configuring dedicated pgBackRest backups, including daily full backups, WAL archiving for PITR, and monthly test restores.

Quick Start

User: "Setting up database for new customer Acme Corp" Me: I'll configure automated backups for Acme Corp:

  • Creating dedicated pgBackRest stanza
  • Setting up daily full backups with 30-day retention
  • Configuring WAL archiving for PITR
  • Scheduling test restores monthly
  • Adding monitoring for backup success

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: fairdb-backup-manager
Download link: https://github.com/jeremylongshore/claude-code-plugins-plus/archive/main.zip#fairdb-backup-manager

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository