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.
备用节点上的逻辑解码(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.
发布评论