Replication Test

pgwatch2 jeva tool ni madad thi aapde continously monitor kari sakie 6ie. pan haal ma aapde aa manually karisu.

sauthi pehla aapde port 5433 wada database ma login karsu

psql postgres --port=5433

tyaar pa6i,

select * from pg_stat_replication;

aa kaink aa rite reply kartu hase

- [ RECORD 1 ] --
pid              | 12648
usesysid         | 16388
usename          | repuser
application_name | walreceiver
client_addr      | 127.0.0.1
client_hostname  | 
Client_port      | 40904
backend_start    | 2025-11-15 13:42:18.65708+00
backend_xmin     | 
state            | streaming
sent_lsn         | 0/3000148
write_Isn        | 0/3000148
flush_Isn        | 0/3000148
replay_Isn       | 0/3000148
write_lag        | 
flush_lag        | 
replay_lag       | 
sync_priority    | 0
sync_state       | async
reply_time       | 2025-11-15 13:50:08.86878+00

aa rite aapde replica mate bhi check kari sakie.

psql postgres --port=5434

tyar pa6i,

select * from pg_stat_wal_receiver;

aa kaink aa rite reply kare 6e.

- [RECORD 1] -----------------------
pid                   | 12647
status                | streaming
receive_start_lsn     | 0/3000000
receive_start_tli     | 1
written_lsn           | 0/3000148
flushed_lsn           | 0/3000148
received_tli          | 1
last_msg_send_time    | 2025-11-15 13:58:19.051062+00
last_msg_receipt_time | 2025-11-15 13:58:19.051247+00
latest_end_lsn        | 0/3000148
latest_end_time       | 2025-11-15 13:42:18.658297+00
slot_name             | some_name
sender host           | localhost
sender port           | 5433
conninfo              | user=repuser passfile=/homerubuntumaster/ pgpass channel_binding=prefer doname=replication host=localhost port=5433 fallback_application _name=walreceiver ssimode=prefer sslcompression=@ sslcertmode=allow sslsni=1 ssl_min_protocol _version=TLSV1.2 gssencmode=prefer krbsrvname=postgres gssdelegatio n=o target_session_attrs=any load_balance _hosts=disable

Try by creating a new table

ek new table primary database ma create kari ne check karie.

create table tbl(id int);
insert into tbl values (1);
insert into tbl values (2);
insert into tbl values (3);
insert into tbl values (4);
insert into tbl values (5);
insert into tbl values (6);
insert into tbl values (7);
insert into tbl values (8);
insert into tbl values (9);

select * from tbl;

tame joso k aama 9 records aavi gaya 6e.

have tame replica database ma login karo.

psql postgres --port=5434

have ahiya simply select ni query thi check karo

select * from tbl;

tame jose k ahiya pan tamne same 9 records mali rehse.

jo tame kai bhi delete or truncate etc... kai bhi changes primary database ma karso, replica database ma ae changes apply thai gaya hase.

Try by creating a new table​

Try by creating a new table