Setup PostgreSQL server for logical replication

sauthi pehla aapde 2 nava cluster create karsu.

initdb -d /tmp/publisher_db
initdb -d /tmp/subscriber_db

Publisher Server setup

have bija koi process sathe koi conflict na thai aetle pehla aapde port number change kari nakhsu 5433.

aa change karva mate /tmp/publisher_db/postgresql.conf file ne open karo. tyar pa6i aema port ne find kari ne change karo.

have logical replication set karva mate search karo wal_level ane aeni value set karo logical.

have aa cluster ne start kari do

pg_ctl -D /tmp/publisher_db start

cluster start thai gayu 6e. have aapde aema connect kari ne ek database banavi lesu.

connect karva mate

psql --port=5433 postgres

have aapde ek database create kari laie.

create database pub;

have tame aa pub database ma connect thai jao.

\c pub;

have tame ahiya ek table create kari aema test records add karsu.

create table table_1(id ini primary key, name varchar);
insert into table_1 values(generate_series(1,10), 'data'||generate_series(1,10));

have records check kari lo

select * from table_1;

aa kaink aa rite result aaptu hase.

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

Subscriber Server setup

have bija koi process sathe koi conflict na thai aetle pehla aapde subscriber cluster mate pan port number change kari nakhsu 5434

aa change karva mate /tmp/subscriber_db/postgresql.conf file ne open karo. tyar pa6i aema port ne find kari ne change karo.

pg_ctl -D /tmp/subscriber_db start

subscriber cluster bhi start thai gayu 6e.

have aema connect karo.

psql --port=5434 postgres

have ek new database create karo sub kari ne.

create database sub;