Does it handle automatic failover?

It provides the implementation patterns and configuration logic for Patroni, which manages automated failover and cluster health.

Can I configure both synchronous and asynchronous replication?

Yes, the skill includes parameters to toggle between 'async' for lower latency and 'sync' for maximum data safety.

Which PostgreSQL versions are supported by this skill?

This skill is optimized for PostgreSQL 16 and later versions, utilizing modern replication features and physical slot management.

How do I monitor the health of my replication nodes?

The skill includes specialized commands to monitor lag size, replay LSNs, and the connection status of all replication slots on the primary node.

PostgreSQL Streaming Replication Manager

Name: PostgreSQL Streaming Replication Manager
Author: pluginagentmarketplace

bypluginagentmarketplace

•

Database Management

Automates the configuration, monitoring, and failover management of PostgreSQL streaming replication clusters.

The PostgreSQL Replication skill provides production-ready patterns for managing database high availability and data redundancy. It simplifies the complex tasks of setting up primary and replica nodes, configuring Write-Ahead Logging (WAL) parameters, and managing physical replication slots for PostgreSQL 16+. Beyond initial setup, it includes robust monitoring tools to track replication lag and provides implementation patterns for Patroni-based high availability, ensuring your database infrastructure remains resilient and performs optimally under both synchronous and asynchronous replication modes.

Key Features

01Support for both synchronous and asynchronous replication modes

021 GitHub stars

03Physical replication slot lifecycle management

04Real-time monitoring of replication lag and replica state diagnostics

05High-availability cluster management using Patroni patterns

06Automated primary and replica server configuration for PostgreSQL 16+

Use Cases

01Configuring automated failover and cluster consensus for critical services

02Deploying a primary-replica database cluster for production redundancy

03Troubleshooting and resolving replication lag in high-load environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill

Key Features

01Support for both synchronous and asynchronous replication modes

021 GitHub stars

03Physical replication slot lifecycle management

04Real-time monitoring of replication lag and replica state diagnostics

05High-availability cluster management using Patroni patterns

06Automated primary and replica server configuration for PostgreSQL 16+

Use Cases

01Configuring automated failover and cluster consensus for critical services

02Deploying a primary-replica database cluster for production redundancy

03Troubleshooting and resolving replication lag in high-load environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill