General support on postgres replication

Поиск
Список
Период
Сортировка
От Vijaykumar Patil
Тема General support on postgres replication
Дата
Msg-id AMAP107MB0469F60A8FD4B12B68281E8BF5BAA@AMAP107MB0469.EURP107.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: General support on postgres replication
Re: General support on postgres replication
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Inzamam Shafiq
Дата:
Сообщение: Re: Connection fails on one system in a address range allowed to connect
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Connection fails on one system in a address range allowed to connect