Logical Replication using publication and subscription

sauthi pehla to pub database ma jao

psql --port=5433 pub

have publication create karo.

aena mate syntax pehla joi laie.

Publication syntax

thoda tables mate publication create karva mate.

CREATE PUBLICATION mypub FOR TABLE table1, table2, table3;

Badha table mate publication create karva mate.

CREATE PUBLICATION mypub FOR ALL TABLES;

Publication matra insert operation mate.

CREATE PUBLICATION insert_only FOR TABLE table1 WITH (publish = 'insert');

Chalo have aapde aa publication no use karie.

CREATE PUBLICATION mypub FOR TABLE table_1; 

have aapde subscription vise josu.

CREATE SUBSCRIPTION mysub CONNECTION 'host=192.168.1.50 port=5432 user=foo dbname=foodb' PUBLICATION mypub, insert_only;

aapde ek subscription ni madad thi multiple publication ne bhi subscribe kari sakie. like,

CREATE SUBSCRIPTION mysub CONNECTION 'host=192.168.1.50 port=5432 user=foo dbname=foodb' PUBLICATION mypub, mypub2, mypub3;

jo aapde aa subscription create to kari levu 6e pan aapde nathi i6ta k ae replicate karva nu start kari de to aa command no use kari sakie 6ie.

CREATE SUBSCRIPTION mysub CONNECTION 'host=192.168.1.50 port=5432 user=foo dbname=foodb' PUBLICATION insert_only WITH (enabled = false);

create subscription mysub connection 'dbname=pub host=localhost user=ubuntumaster port=5433' publication mypub;

The above command will start logical replication.