惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

T
Threatpost
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
S
Security Affairs
N
News and Events Feed by Topic
T
Tenable Blog
P
Proofpoint News Feed
W
WeLiveSecurity
Simon Willison's Weblog
Simon Willison's Weblog
Google DeepMind News
Google DeepMind News
C
CERT Recently Published Vulnerability Notes
Help Net Security
Help Net Security
I
Intezer
T
Threat Research - Cisco Blogs
S
Secure Thoughts
C
Cyber Attacks, Cyber Crime and Cyber Security
L
Lohrmann on Cybersecurity
AWS News Blog
AWS News Blog
Google Online Security Blog
Google Online Security Blog
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
Know Your Adversary
Know Your Adversary
Project Zero
Project Zero
The Hacker News
The Hacker News
Security Archives - TechRepublic
Security Archives - TechRepublic
T
Tor Project blog
N
News | PayPal Newsroom
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
Hacker News - Newest:
Hacker News - Newest: "LLM"
A
Arctic Wolf
Forbes - Security
Forbes - Security
O
OpenAI News
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
Security Latest
Security Latest
P
Palo Alto Networks Blog
S
Schneier on Security
S
Securelist
C
Cybersecurity and Infrastructure Security Agency CISA
H
Heimdal Security Blog
V
Vulnerabilities – Threatpost
www.infosecurity-magazine.com
www.infosecurity-magazine.com
博客园_首页
T
Troy Hunt's Blog
Latest news
Latest news
Recent Announcements
Recent Announcements
MyScale Blog
MyScale Blog
人人都是产品经理
人人都是产品经理
L
LINUX DO - 热门话题
M
MIT News - Artificial intelligence
N
Netflix TechBlog - Medium
V
Visual Studio Blog
H
Hacker News: Front Page

博客园 - Hey,Coder!

Elasticsearch ILM 与 Data Stream 概念及实例说明文档 portainer httphelper封装 Ocelot + Consul + SignalR 粘性会话 正交软件架构 rabbitmq总结与c#示例 docker rabbitmq quartz dashboard docker consul registrator 服务自动注册consul 微服务动态扩容 ubuntu24.04 安装docker RAG 检索增强生成 软考 - 架构设计师 知识点总结 c# MailKit3.4.3 发送邮件、附件 nginx 反向代理postgresql c# 信号量 elsa 3.5 中间件记录最后执行的节点数据 xp密钥 c# System.Text.Json 反序列化Dictionary<string,object>时未转换基础类型的处理方法 docker配置代理 openclaw 接入 LMStudio的模型服务 wpf canvas 移动 缩放 windows平台openclaw搭建 wpf scrollerview触摸滚动 c# 动态切换sqlsugar连接字符串 c# Elastic.Clients.Elasticsearch 动态查询 c# es 封装Elastic.Clients.Elasticsearch c# scrollerview滚动到指定元素位置 WPF 重写Expander 基于elsa工作流封装一套变量、组件的体系 常用活动重写 DynamicExpresso 轻量级动态表达式库 c# elsa 3.5.2 程序化工作流常用功能及自定义中间件 leaflet docker 连接老版本的sqlserver ssl错误 c# quartz 动态创建任务 控制任务运行和停止 依赖注入 cefsharp 模拟点击 批量重置数据库的数据 docker 复制远程镜像本地并创建容器 c# newtonsoft dynamic
docker postgresql17 主从复制
Hey,Coder! · 2026-06-18 · via 博客园 - Hey,Coder!
//启动主库容器
sudo docker run -d  --name postgres -e TZ=Asia/Shanghai -e POSTGRES_USER=dev  -e POSTGRES_PASSWORD=testPassword --restart always -p 5432:5432 -v /server/db/pg/data:/var/lib/postgresql/data postgres:17.5

//创建复制专用账号
sudo docker exec -it postgres psql -U dev  -c "CREATE USER replicator WITH REPLICATION LOGIN PASSWORD 'testPassword';"

//修改 pg_hba.conf,放行复制连接
//docker exec postgres sh -c 'echo "host replication replicator 0.0.0.0/0 md5" >> /var/lib/postgresql/data/pg_hba.conf'
docker exec -it pg-primary bash
# 容器内执行:
echo "host replication replicator 0.0.0.0/0 md5" >> /var/lib/postgresql/data/pg_hba.conf
exit


//打开 WAL 流复制参数
docker exec postgres  psql -U dev  -c "ALTER SYSTEM SET wal_level = 'replica';"
docker exec postgres  psql -U dev  -c "ALTER SYSTEM SET max_wal_senders = 10;"
docker exec postgres  psql -U dev  -c "ALTER SYSTEM SET max_replication_slots = 10;"
docker exec postgres  psql -U dev   -c "ALTER SYSTEM SET hot_standby = 'on';"

//启主库让 WAL level 生效
docker restart postgres 


//创建从库的文件目录
mkdir /server/db/pg_slave/data

//启动一个一次性容器,执行 pg_basebackup把主库数据写到  /server/db/pg_slave/data:

docker run --rm \
-e PGPASSWORD='testPassword' \
  -v  /server/db/pg_slave/data:/var/lib/postgresql/data \
  postgres:17.5 \
  pg_basebackup \
    -h 127.0.0.1 \
    -p 5432 \
    -U replicator \
    -D /var/lib/postgresql/data \
    -Xs -P -R -v


//启动从库容器
docker run -d \
  --name pg-replica \
  -p 5433:5432 \
  -v /server/db/pg_slave/data:/var/lib/postgresql/data \
  -e POSTGRES_PASSWORD=testPassword \
  -e TZ=Asia/Shanghai \
  postgres:17.5

[参考]
pg16主备主从