postgres 逻辑复制demo

sql

create extension "uuid-ossp";

CREATE TABLE demo
(
    id varchar DEFAULT uuid_generate_v4() PRIMARY KEY,
    v_data varchar,
    t_create timestamp DEFAULT now(),
    v_from varchar
);

create publication mypub for table demo;

create subscription mysub_qianxinan connection 'host=qianxinan port=5432 user=postgres dbname=postgres' publication mypub;
create subscription mysub_guian connection 'host=guian port=5432 user=postgres dbname=postgres' publication mypub;


insert into demo (v_data ,v_from) values ('test111','guian');

insert into demo (v_data ,v_from) values ('test221','xingyi');
insert into demo (v_data ,v_from) values ('teadfad','qianxinan');