Test Logical replication

pg_dump thi aapde jyare table copy karelu hatu tyare aema data aavel noto. mysub subscription create karya pa6i tame table_1 ne sub database ma (subscription cluster ma) check karso to tame joi sakso k aema data 6e.

select * from table_1;

tamne data kaink aa rite jova malse.

id | name
---+------
 1 | data1
 2 | data2
 3 | data3
 4 | data4
 5 | data5
 6 | data6
 7 | data7
 8 | data8
 9 | data9
 10| data10
(10 rows)

Chalo ek vakhat publication cluster ma new records add kari ne joi laie.

for that, go to pub database.

psql --port=5433 pub

have 10 new records insert karo and check karo.

insert into table_1 values(generate_series(11,20), 'data'||generate_series(11,20));
select * from table_1;

tamne result kaink aa rite

id | name
---+------
 1 | data1
 2 | data2
 3 | data3
 4 | data4
 5 | data5
 6 | data6
 7 | data7
 8 | data8
 9 | data9
 10| data10
 11| data11
 12| data12
 13| data13
 14| data14
 15| data15
 16| data16
 17| data17
 18| data18
 19| data19
 20| data20
(20 rows)

have tame quickly exit kari ne sub database ma jao.

psql --port=5434 sub

tya have check karo.

select * from table_1;

tamne result kaink aa rite

id | name
---+------
 1 | data1
 2 | data2
 3 | data3
 4 | data4
 5 | data5
 6 | data6
 7 | data7
 8 | data8
 9 | data9
 10| data10
 11| data11
 12| data12
 13| data13
 14| data14
 15| data15
 16| data16
 17| data17
 18| data18
 19| data19
 20| data20
(20 rows)

to ahi aapde insert operation karelu hatu pub ma pan ae sub ma pan aapde joi sakie 6ie.

aa prakare jo tamare update, delete k truncate operation mate bhi check karvu hoi to kari sako 6o, in short tamne result ma sync thayel data jova malse.