Re: Getting following error in using cursor to fetch the recordsfrom a large table in c language - Mailing list pgsql-general

On Thu, 2019-10-31 at 05:18 +0000, M Tarkeshwar Rao wrote:
[queries get canceled on the standby]
> You are absolutely right. This is the issue with us.
> If we retry the query again. Will it be successful? 

Sometimes :^/

> Can you please suggest how to configure hot_standby_feedback?

You set it to "on", then you get no query cancellation because of
VACUUM (at the price of potential bloat on the primary server).

Your query can still get canceled by conflichts with ACCESS EXCLUSIVE
locks that are taken by TRUNCATE, ALTER/DROP TABLE and similar
as well as autovacuum truncation.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com