备用节点上的逻辑解码(Logical decoding on a standby node)

备用节点上的逻辑解码(Logical decoding on a standby node)

PostgreSQL 9.4引入了逻辑解码： http ： //www.postgresql.org/docs/9.4/static/logicaldecoding.html

它还具有Cascade Streaming Replication： http ： //www.postgresql.org/docs/9.4/static/warm-standby.html#CASCADING-REPLICATION

逻辑解码似乎基于流复制。 但是，PostgreSQL服务器将拒绝在热备用服务器上启动逻辑复制插槽。 它只允许主节点上的逻辑解码。

是什么阻止热备用节点使用逻辑解码以级联方式复制自身？

PostgreSQL 9.4 introduced Logical Decoding: http://www.postgresql.org/docs/9.4/static/logicaldecoding.html

It also has Cascade Streaming Replication: http://www.postgresql.org/docs/9.4/static/warm-standby.html#CASCADING-REPLICATION

Logical Decoding seems to be based on Streaming Replication. However a PostgreSQL server will refuse to start a Logical replication slot on a hot standby. It will only allow Logical Decoding on the master node.

What prevents a hot standby node to replicate itself in cascade using Logical Decoding?

最满意答案

为PostgreSQL 10提交了一个补丁，但没有进入 。

PostgreSQL 11的工作仍在继续 。

一旦基本功能在postgres中，像pglogical这样的客户端将需要修改以支持从备用数据库进行流式传输。

A patch was submitted for PostgreSQL 10, but didn't get in.

Work continues for PostgreSQL 11.

Clients like pglogical will need modification to support streaming from a standby once the basic functionality is in postgres.