Re: Getting following error in using cursor to fetch the recordsfrom a large table in c language

On Wed, 2019-10-30 at 16:59 +0000, M Tarkeshwar Rao wrote:
> Getting following error in using cursor to fetch the records from a large table in c language.
> Can you please suggest why it is coming and what is the remedy for this.
> 
> Error Details
> -----------------
> Failed to execute the sql command close:
> mycursor_4047439616_1571970686004430275FATAL:  terminating connection due to conflict with recovery
> DETAIL:  User query might have needed to see row versions that must be removed.
> HINT:  In a moment you should be able to reconnect to the database and repeat your command.

This is not a proble with your program.

Your query is running against a standby server with "hot_standby" on,
and there are conflicts between replication and your query.

If you increase "max_standby_streaming_delay" in "postgresql.conf" on
the standby, your query will be given more time to complete.
This will, however, cause replay of the replicated changes to be delayed.

Yours,
Laurenz Albe