General support on postgres replication - Mailing list pgsql-general

From Vijaykumar Patil
Subject General support on postgres replication
Date
Msg-id AMAP107MB0469F60A8FD4B12B68281E8BF5BAA@AMAP107MB0469.EURP107.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: General support on postgres replication
Re: General support on postgres replication
List pgsql-general

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

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

Please consider the environment before printing this email.

Classification: Internal

Attachment

pgsql-general by date:

Previous
From: Inzamam Shafiq
Date:
Subject: Re: Connection fails on one system in a address range allowed to connect
Next
From: Laurenz Albe
Date:
Subject: Re: Connection fails on one system in a address range allowed to connect