Skills
.Work. You
Rest

postgresql-backup-recovery

Community

Master PostgreSQL backup and recovery.

Software Engineering#postgresql#backup#recovery#pg_dump#pitr#pg_basebackup#wal archiving
Authorrudi-bruchez
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides comprehensive strategies and tools for backing up and recovering PostgreSQL databases, ensuring data safety and business continuity against data loss or corruption.

Core Features & Use Cases

  • Backup Strategy Design: Choose between logical (pg_dump) and physical (pg_basebackup) backups based on RPO/RTO.
  • Automated Backups: Configure pg_dump for logical backups and WAL archiving for physical backups with PITR.
  • Point-in-Time Recovery (PITR): Restore your database to any specific moment in time using WAL archives.
  • Use Case: Recover your production PostgreSQL database to a state just before a critical data corruption incident occurred, minimizing data loss.

Quick Start

Execute a full logical backup of the 'mydatabase' database using the custom format.

Dependency Matrix

Required Modules

None required

Components

scriptsreferencesexamples

💻 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: postgresql-backup-recovery
Download link: https://github.com/rudi-bruchez/dba-skills/archive/main.zip#postgresql-backup-recovery

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

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.