openGauss这么多工具？到底要选哪个？（535）

#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/

示例

1. 创建名为test_slot的逻辑复制槽。

   pg_recvlogical -d postgres -S test_slot -p 26000 --create
   

2. 开启流式解码，结果输出到stdout。

   pg_recvlogical -d postgres -S test_slot -p 26000 --start -v -f -
   pg_recvlogical: starting log streaming at 0/0 (slot test_slot)
   pg_recvlogical: initiated streaming
   pg_recvlogical: confirming write up to 0/0, flush to 0/0 (slot test_slot)
   pg_recvlogical: confirming write up to 0/2A342E8, flush to 0/2A342E8 (slot test_slot)
   pg_recvlogical: confirming write up to 0/2A34320, flush to 0/2A34320 (slot test_slot)
   pg_recvlogical: confirming write up to 0/2A34320, flush to 0/2A34320 (slot test_slot)
   BEGIN 16039
   table public.t: INSERT: a[integer]:4 b[integer]:4
   COMMIT 16039
   pg_recvlogical: confirming write up to 0/2A34450, flush to 0/2A34450 (slot test_slot)
   pg_recvlogical: confirming write up to 0/2A34450, flush to 0/2A34450 (slot test_slot)
   

3. 删除逻辑复制槽。

   pg_recvlogical -d postgres -S test_slot -p 26000 --drop
   

#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/