Hi Laurenz,
Please find the log details :-
2023-11-22 04:32:47 EST +AFs-1278503+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: entering standby mode
ERROR: +AFs-037+AF0-: archive-get command requires option: pg1-path
HINT: does this stanza exist?
ERROR: +AFs-037+AF0-: archive-get command requires option: pg1-path
HINT: does this stanza exist?
2023-11-22 04:32:47 EST +AFs-1278503+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: redo starts at 1/27000028
ERROR: +AFs-037+AF0-: archive-get command requires option: pg1-path
HINT: does this stanza exist?
2023-11-22 04:32:47 EST +AFs-1278503+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: consistent recovery state reached at 1/27000100
2023-11-22 04:32:47 EST +AFs-1278499+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: database system is ready to accept read-only connections
ERROR: +AFs-037+AF0-: archive-get command requires option: pg1-path
HINT: does this stanza exist?
2023-11-22 04:32:47 EST +AFs-1278509+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: started streaming WAL from primary at 1/28000000 on timeline 36
2023-11-22 04:33:02 EST +AFs-1278511+AF0-: user+AD0AWw-unknown+AF0-,db+AD0AWw-unknown+AF0-,app+AD0AWw-unknown+AF0-,client+AD0-10.125.0.120LOG: connection received: host+AD0-10.125.0.120 port+AD0-48408
2023-11-22 04:33:02 EST +AFs-1278511+AF0-: user+AD0-pensieve,db+AD0-postgres,app+AD0AWw-unknown+AF0-,client+AD0-10.125.0.120LOG: connection authorized: user+AD0-pensieve database+AD0-postgres
2023-11-22 04:33:31 EST +AFs-1278503+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: recovery stopping before commit of transaction 25628, time 2023-11-22 04:33:31.454379-05
2023-11-22 04:33:31 EST +AFs-1278503+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: redo done at 1/2800BBB0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 43.73 s
2023-11-22 04:33:31 EST +AFs-1278509+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-FATAL: terminating walreceiver process due to administrator command
ERROR: +AFs-037+AF0-: archive-get command requires option: pg1-path
HINT: does this stanza exist?
2023-11-22 04:33:31 EST +AFs-1278503+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: selected new timeline ID: 37
ERROR: +AFs-037+AF0-: archive-get command requires option: pg1-path
HINT: does this stanza exist?
2023-11-22 04:33:31 EST +AFs-1278503+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: archive recovery complete
2023-11-22 04:33:31 EST +AFs-1278501+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: checkpoint starting: end-of-recovery immediate wait
2023-11-22 04:33:31 EST +AFs-1278501+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: checkpoint complete: wrote 10 buffers (0.0+ACU-)+ADs- 0 WAL file(s) added, 0 removed, 0 recycled+ADs- writ
e+AD0-0.026 s, sync+AD0-0.003 s, total+AD0-0.038 s+ADs- sync files+AD0-9, longest+AD0-0.002 s, average+AD0-0.001 s+ADs- distance+AD0-16430 kB, estimate+AD0-16430 kB
2023-11-22 04:33:31 EST +AFs-1278499+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: database system is ready to accept connections
Host key verification failed.
rsync: connection unexpectedly closed (0 bytes received so far) +AFs-sender+AF0-
Thanks
Vijay
Classification: Internal
-----Original Message-----
From: Laurenz Albe +ADw-laurenz.albe+AEA-cybertec.at+AD4-
Sent: 23 November 2023 14:14
To: Vijaykumar Patil +ADw-vijaykumar.patil+AEA-maersk.com+AD4AOw- pgsql-general+AEA-lists.postgresql.org
Subject: Re: General support on postgres replication
This message was sent from outside of your organization. Please do not click links or open attachments unless you recognize the source of this email and know the content is safe.
On Wed, 2023-11-22 at 08:57 +-0000, Vijaykumar Patil wrote:
+AD4- I have created streaming replication with two nodes .
+AD4-
+AD4- One is primary and 2nd one is standby but after doing any DML or DDL
+AD4- operation on primary Walreceiver process is terminated on standby and
+AD4- standby database is opening in read write mode.
+AD4-
+AD4- Below are the error details .
+AD4-
+AD4- 2023-11-22 03:39:58 EST +AFs-1275942+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG:
+AD4- recovery stopping before commit of transaction 25627, time 2023-11-22
+AD4- 03:39:58.013764-05
+AD4- 2023-11-22 03:39:58 EST +AFs-1275942+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-LOG: redo
+AD4- done at 1/260059E0 system usage: CPU: user: 0.02 s, system: 0.04 s,
+AD4- elapsed: 5197.90 s
+AD4- 2023-11-22 03:39:58 EST +AFs-1276846+AF0-: user+AD0-,db+AD0-,app+AD0-,client+AD0-FATAL:
+AD4- terminating walreceiver process due to administrator command
+AD4- ERROR: +AFs-037+AF0-: archive-get command requires option: pg1-path
+AD4- HINT: does this stanza exist?
It looks like you have a bad +ACI-restore+AF8-command+ACI- configured.
It would be intereseting to see the log lines before the ones you are showing.
Yours,
Laurenz Albe
+AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXw-
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+IBk-s collection and processing of your personal data and your rights as a data subject in our privacy policy +ADw-https://www.maersk.com/front-page-requirements/privacy-policy+AD4-
Please consider the environment before printing this email.
