could not send replication command “START_REPLICATION“: ERROR: replication slot does noes not exist

最新推荐文章于 2024-08-06 11:04:47 发布

蜡津

最新推荐文章于 2024-08-06 11:04:47 发布

阅读量559

点赞数

文章标签： postgresql 数据库运维

本文链接：https://blog.youkuaiyun.com/weixin_43084715/article/details/132365225

版权

文章讲述了如何在PostgreSQL主库上创建物理复制槽，并在备库尝试接收的过程，遇到replicationslot不存在的错误，提示了使用-hdb206选项连接的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在主库创建物理复制槽：

SELECT * FROM pg_create_physical_replication_slot('slot_s1');

在备库测试：

[postgres@db223 pg_wal]$ pg_receivewal -U postgres -D /home/postgres/pgarch/ -S test_slot -v
pg_receivewal: starting log streaming at 11C/10000000 (timeline 8)
pg_receivewal: error: could not send replication command "START_REPLICATION": ERROR: replication slot "test_slot" does not exist
pg_receivewal: disconnected; waiting 5 seconds to try again

需要指定 -h db206

[postgres@db223 pgarch]$ pg_receivewal -h db206 -U postgres -D /home/postgres/pgarch/ -S test_slot -v