Postgres Pro
Downloads
Home   >   mailing lists

Re: General support on postgres replication - Mailing list pgsql-general

From Ron Johnson
Subject Re: General support on postgres replication
Date
Msg-id CANzqJaBqysmWn9qsoY4-UHy+MTgOLH0Qtp0YxR+zWi-Xk0Gpaw@mail.gmail.com
Whole thread Raw
In response to General support on postgres replication  (Vijaykumar Patil <vijaykumar.patil@maersk.com>)
List pgsql-general
Tree view
On Wed, Nov 22, 2023 at 11:17 AM Vijaykumar Patil <vijaykumar.patil@maersk.com> wrote:

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?


What have you done about fixing that quite explicit ERROR message, and its attendant HINT?

pgsql-general by date:

Previous
From: Atul Kumar
Date:
Subject: strange behavior of pg_hba.conf file
Next
From: Andreas Kretschmer
Date:
Subject: Re: strange behavior of pg_hba.conf file