#openGauss #入门 #安装 #数据库 #开源
知识来源：docs-opengauss.osinfra.cn/zh/
示例
执行gs_retrieve，结果输出到stdout。
gs_retrieve --newhost=127.0.0.1 --newport=25821 --oldhost=127.0.0.1 --oldport=25800 -U openGauss -W --dbname=postgres -P mppdb_decoding -f -
gs_retrieve: begin to search for diverge lsn.
INFO: Try to bind walsender thread to available CPUs in threadpool.
gs_retrieve: find diverge lsn 0/14000350
gs_retrieve: found proper restart_lsn 0/140000D8.
gs_retrieve: ready to connect old-master database and do logical replication.
Password:
location | xid | data
0/140001C8 | 16020 | BEGIN 16020
0/140001C8 | 16020 | {"table_name":"public.t1","op_type":"INSERT","columns_name":["a","b"],"columns_type":["integer","integer"],"columns_val":["14","14"],"old_keys_name":[],"old_keys_type":[],"old_keys_val":[]}
0/140003B0 | 16020 | {"table_name":"public.t1","op_type":"INSERT","columns_name":["a","b"],"columns_type":["integer","integer"],"columns_val":["16","16"],"old_keys_name":[],"old_keys_type":[],"old_keys_val":[]}
0/14000538 | 16020 | COMMIT 16020 (at 2024-02-05 14:46:35.203057+08) CSN 2155
0/14000538 | 16022 | BEGIN 16022
0/14000538 | 16022 | {"table_name":"public.t1","op_type":"INSERT","columns_name":["a","b"],"columns_type":["integer","integer"],"columns_val":["17","17"],"old_keys_name":[],"old_keys_type":[],"old_keys_val":[]}
0/14000638 | 16022 | COMMIT 16022 (at 2024-02-05 14:46:40.965957+08) CSN 2156
0/14038798 | 16739 | BEGIN 16739
0/143C7530 | 16739 | COMMIT 16739 (at 2024-02-06 01:34:11.237605+08) CSN 2157
0/143EE1A0 | 16741 | BEGIN 16741
0/1477D390 | 16741 | COMMIT 16741 (at 2024-02-06 07:17:19.45874+08) CSN 2159
gs_retrieve: retrieve data finished.
#openGauss #入门 #安装 #数据库 #开源
