On Wed, Nov 22, 2023 at 11:17 AM Vijaykumar Patil < vijaykumar.pa...@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?