openGauss系数据库逻辑复制实现双写

好久之前写过一篇关于逻辑复制的文章openGauss/MogDB 同一个实例下完成发布订阅,现在在此基础上再添加一篇关于逻辑复制实现双写的案例,本来准备了3个环境,分别是306、501和505,奈何在5版本向3版本订阅的时候,出现了报错,但也将整个过程都记录下来吧。

环境准备

节点信息

MogDB=# select version(); version ------------------------------------------------------------------------------------------------------------------------------------------------------ (MogDB 5.0.5 build b77f1a82) compiled at 2023-12-08 03:11:47 commit 0 last mr 1804 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit (1 row) MogDB=# show wal_level ; wal_level ----------- logical (1 row) MogDB=# select version(); version ------------------------------------------------------------------------------------------------------------------------------------------------------ (MogDB 5.0.1 build ae6d2ada) compiled at 2023-08-16 09:07:43 commit 0 last mr 1804 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit (1 row) MogDB=# show wal_level ; wal_level ----------- logical (1 row) MogDB=# select version(); version ------------------------------------------------------------------------------------------------------------------------------------------------------ (MogDB 3.0.6 build 0e82b772) compiled at 2023-09-08 03:05:33 commit 0 last mr 1801 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit (1 row) MogDB=# show wal_level ; wal_level ----------- logical (1 row)