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?
2023-11-22 03:39:58 EST [1275942]: user=,db=,app=,client=LOG: archive recovery
complete
2023-11-22 03:39:58 EST [1275940]: user=,db=,app=,client=LOG: checkpoint
starting: end-of-recovery immediate wait
2023-11-22 03:39:58 EST [1275940]: user=,db=,app=,client=LOG: checkpoint
complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled;
write=0.022 s, sync=0.003 s, total=0.033 s; sync files=6, longest=0.002 s,
average=0.001 s; distance=22 kB, estimate=34772 kB
2023-11-22 03:39:58 EST [1275938]: user=,db=,app=,client=LOG: database system
is ready to accept connections
Thanks & Regards
Vijaykumar
Database Operations
[cid:[email protected]]
Maersk Global Service Centre, Pune.
________________________________
The information contained in this message is privileged and intended only for
the recipients named. If the reader is not a representative of the intended
recipient, any review, dissemination or copying of this message or the
information it contains is prohibited. If you have received this message in
error, please immediately notify the sender, and delete the original message
and attachments.
Maersk will as part of our communication and interaction with you collect and
process your personal data. You can read more about Maersk's collection and
processing of your personal data and your rights as a data subject in our
privacy policy <https://www.maersk.com/front-page-requirements/privacy-policy>
Please consider the environment before printing this email.
Classification: Internal
