Which PostgreSQL versions are compatible with this skill?

The skill is specifically designed for PostgreSQL 16+ but includes foundational patterns applicable to most modern PostgreSQL versions.

How does this skill assist with disaster recovery?

It provides a clear strategy table comparing recovery speeds and use cases, ensuring you choose the right backup method for your specific RTO and RPO requirements.

What backup types does this skill support?

The skill supports three primary types: logical backups (pg_dump), physical cluster backups (pg_basebackup), and Point-In-Time Recovery (PITR) via WAL archiving.

Does it include configuration for WAL archiving?

Yes, it includes standardized patterns for enabling archive_mode and setting up reliable archive_commands for continuous data protection.

Can this skill help with large database restores?

Yes, it provides patterns for parallel restores and performance optimization using the pg_restore utility with custom and directory formats.

PostgreSQL Backup & Recovery

Name: PostgreSQL Backup & Recovery
Author: pluginagentmarketplace

bypluginagentmarketplace

•

Database Management

Implements production-ready PostgreSQL backup strategies including logical, physical, and point-in-time recovery patterns.

This skill provides specialized domain knowledge for database administrators and developers to implement robust data protection strategies within PostgreSQL environments. It offers standardized patterns for logical backups using pg_dump, full cluster physical backups via pg_basebackup, and advanced Point-In-Time Recovery (PITR) through WAL archiving. Whether you need portable database exports or high-availability disaster recovery configurations, this skill ensures best practices are followed for data integrity, storage efficiency, and recovery speed.

Key Features

01Advanced Point-In-Time Recovery (PITR) and WAL archiving configuration

02Logical backup automation using pg_dump with parallel processing support

03Optimized recovery procedures using pg_restore with performance tuning

041 GitHub stars

05Physical cluster backup implementation via pg_basebackup

06Comprehensive troubleshooting guides for common backup and restore failures

Use Cases

01Configuring automated daily logical backups for production and staging environments

02Setting up Write-Ahead Logging (WAL) for granular data recovery and disaster readiness

03Migrating large databases between servers using optimized physical backup patterns

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pluginagentmarketplace/custom-plugin-postgresql postgresql-backup

For use in Claude.ai and ChatGPT

Download Skill