Data Replication Setup

Sets up database replication for high availability and disaster recovery scenarios. Covers PostgreSQL primary-standby configurations, logical replication, and multi-master setups. You'd reach for this when spinning up read replicas, configuring cross-region failover, or building out a disaster recovery strategy. The included reference guides walk through WAL configuration, replication user setup, and monitoring approaches. It's solid foundational work that saves you from piecing together replication configs from scattered documentation, though you'll still need to tune parameters for your specific load and availability requirements.

skills.sh installs: 424
GitHub stars: 379
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill data-replication-setup --agent claude-code

Installs into .claude/skills of the current project.

Files

Overview

Configure database replication for disaster recovery, load distribution, and high availability. Covers master-slave, multi-master replication, and monitoring strategies.

When to Use

High availability setup
Disaster recovery planning
Read replica configuration
Multi-region replication
Replication monitoring and maintenance
Failover automation
Cross-region backup strategies

Quick Start

PostgreSQL - Configure Primary Server:

-- On primary server: postgresql.conf
-- wal_level = replica
-- max_wal_senders = 10
-- wal_keep_size = 1GB

-- Create replication user
CREATE ROLE replication_user WITH REPLICATION ENCRYPTED PASSWORD 'secure_password';

-- Allow replication connections: pg_hba.conf
-- host    replication     replication_user   standby_ip/32    md5

-- Enable WAL archiving for continuous backup
-- archive_mode = on
-- archive_command = 'test ! -f /archive/%f && cp %p /archive/%f'