数据库复制设置指南：PostgreSQL主从复制、灾难恢复与高可用性配置

data-replication-setup by aj-geddes/useful-ai-prompts

120 周安装量

141 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill data-replication-setup

数据库开发运维系统架构

🇨🇳中文介绍

数据复制设置

概述

配置数据库复制以实现灾难恢复、负载分配和高可用性。涵盖主从复制、多主复制以及监控策略。

使用场景

高可用性设置
灾难恢复规划
只读副本配置
多区域复制
复制监控与维护
故障转移自动化
跨区域备份策略

快速开始

PostgreSQL - 配置主服务器：

-- 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'

参考指南

references/ 目录下的详细实现：

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

指南	内容
主从（主-备）设置	主从（主-备）设置
逻辑复制	逻辑复制
主从设置	主从设置

🇺🇸English

Data Replication Setup

Overview
When to Use
Quick Start
Reference Guides
Best Practices

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'

Reference Guides

Detailed implementations in the references/ directory:

Guide	Contents
Master-Slave (Primary-Standby) Setup	Master-Slave (Primary-Standby) Setup
Logical Replication	Logical Replication
Master-Slave Setup	Master-Slave Setup

Best Practices

✅ DO

Follow established patterns and conventions
Write clean, maintainable code
Add appropriate documentation
Test thoroughly before deploying

❌ DON'T

Skip testing or validation
Ignore error handling
Hard-code configuration values

Weekly Installs

104

Repository

aj-geddes/usefu…-prompts

GitHub Stars

126

First Seen

Jan 21, 2026

Security Audits

Gen Agent Trust HubWarn SocketPass SnykFail

Installed on

opencode87

gemini-cli86

codex82

claude-code82

cursor80

github-copilot70