Hi Team,
Need some support for below issue .
I have created streaming replication with two nodes .
One is primary and 2nd one is standby but after doing any DML or DDL operation on primary Walreceiver process is terminated on standby and standby database is opening in read write mode.
Below are the error details .
2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: recovery stopping before commit of transaction 25627, time 2023-11-22 03:39:58.013764-05
2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: redo done at 1/260059E0 system usage: CPU: user: 0.02 s, system: 0.04 s, elapsed: 5197.90 s
2023-11-22 03:39:58 EST [1276846]: user=,db=,app=,client=FATAL: terminating walreceiver process due to administrator command
ERROR: [037]: archive-get command requires option: pg1-path
HINT: does this stanza exist?
2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: selected new timeline ID: 37
ERROR: [037]: archive-get command requires option: pg1-path
HINT: does this stanza exist?