Re: Queries in replica are failing

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
Cc: Siraj G <tosiraj(dot)g(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Queries in replica are failing
Date: 2024-05-29 21:17:19
Message-ID: 9728204dee5eb1ee9dedd421146d588052761bcd.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 transaction logs: [18218].

Ah, then you are recovering from an archive.

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

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ROHIT SACHDEVA 2024-05-30 01:29:31 Re: Queries in replica are failing
Previous Message ROHIT SACHDEVA 2024-05-29 17:04:46 Re: Queries in replica are failing