Re: Queries in replica are failing - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Queries in replica are failing
Date
Msg-id 9728204dee5eb1ee9dedd421146d588052761bcd.camel@cybertec.at
Whole thread Raw
In response to Re: Queries in replica are failing  (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
Responses Re: Queries in replica are failing
List pgsql-admin
On Wed, 2024-05-29 at 22:34 +0530, ROHIT SACHDEVA wrote:
> I received this error when i set  max_standby_streaming_delay to -1 and max_standby_archive_delay to 30 seconds.
>
> The following processes were terminated on your read replica because they were interfering with the replay of
transactionlogs: [18218]. 

Ah, then you are recovering from an archive.

In that case, set "max_standby_archive_delay" to -1 as well.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: ROHIT SACHDEVA
Date:
Subject: Re: Queries in replica are failing
Next
From: ROHIT SACHDEVA
Date:
Subject: Re: Queries in replica are failing