Queries in replica are failing

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Queries in replica are failing
Date: 2024-05-16 12:01:23
Message-ID: CAC5iy63x1wGXLn8ULtnuPf67o=oCLyFtxvoME4WgezYhKq2YNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello -

Queries in replica instance are failing with the error
"cancelling statement due to conflict with recovery". I was checking two
parameters (max_standby_archive_delay and max_standby_streaming_delay) which
may allow the queries to run within the time defined in those.

Is it recommended to set those? Is there any other suggestion to tackle
this?

Regards
Siraj

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matt Pearson 2024-05-16 12:13:18 Re: Queries in replica are failing
Previous Message hubert depesz lubaczewski 2024-05-16 11:40:37 Re: Where to learn PostgreSQL for free?