skills.rest
jeremylongshore
jeremylongshoreCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

fairdb-backup-manager

Automate FairDB PostgreSQL backup and recovery with pgBackRest and Wasabi S3.

2.6k|379|Updated Oct 10, 2025
Search Tags:#PostgreSQL#disaster recovery#backup#pgBackRest#FairDB#Wasabi S3#PITR
One-click install
npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill fairdb-backup-manager
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fairdb-backup-manager
Source: https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/plugins/devops/fairdb-operations-kit/skills/fairdb-backup-manager
Command: npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill fairdb-backup-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

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

Frequently Asked Questions about fairdb-backup-manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate PostgreSQL backups with pgBackRest and S3 storage?▼

PostgreSQL backups with pgBackRest automate full, differential, and incremental backup cycles to S3-compatible storage like Wasabi. Configure a pgBackRest stanza, set retention policies, enable compression and encryption, and schedule backups to run automatically on your FairDB deployment.

Can I perform point-in-time recovery on FairDB PostgreSQL databases?▼

Yes. Point-in-time recovery (PITR) restores your FairDB database to any specific timestamp by replaying archived WAL files. pgBackRest with WAL archiving enables this by preserving transaction logs continuously, allowing you to recover to the exact moment before data loss occurred.

What's the best way to verify PostgreSQL backups are working and recoverable?▼

Backup verification checks backup integrity and tests restore procedures regularly. Monitor backup job status, validate backup metadata, run test restores monthly, and alert on failures to confirm your FairDB backups are complete, encrypted, and actually recoverable before disaster strikes.

How do I set up disaster recovery for a new FairDB customer with automated backups?▼

Create a dedicated pgBackRest stanza for the customer, configure daily full backups with 30-day retention to Wasabi S3, enable WAL archiving for PITR capability, schedule monthly test restores, and add monitoring alerts. This ensures encrypted, compressed backups meet compliance and recovery-time requirements.

Does pgBackRest support encrypted and compressed backups for compliance?▼

Yes. pgBackRest backups support encryption and compression by default, reducing storage costs and meeting data protection compliance requirements. Combined with retention policies and monitoring, this ensures FairDB backups meet security and regulatory standards for disaster recovery.

What monitoring and alerting should I configure for PostgreSQL backup health?▼

Monitor backup completion status, success rates, and WAL archiving lag to catch failures early. Configure alerts on backup job failures, retention policy violations, and restore test failures. This proactive monitoring ensures your FairDB backup strategy remains reliable and compliant.

Related Skills

Explore More Software Engineering Skills→
h4vzzh4vzz
33

database-backup

Generate scheduled backup scripts for PostgreSQL, MySQL, and MongoDB databases.

Community
Advanced
cffrankcffrank

d1-time-travel

Back up D1 databases and restore them with Time Travel bookmarks.

Community
Advanced
sitharaj88sitharaj88
1

setup-monitoring

Configure application monitoring, logging, error tracking, and alerting with Sentry, Datadog, Grafana, Prometheus, and OpenTelemetry.

Community
Advanced
rudi-bruchezrudi-bruchez

postgresql-backup-recovery

Manage PostgreSQL backups and recovery with pg_dump, pg_basebackup, and WAL archiving.

Community
Advanced