Re: Does export operation cancel SQLs?

Laurenz Albe schrieb am 19.02.2025 um 09:43:
>> We have PostgreSQL 16 running in GCP cloud SQL. When export job runs we
>> are noticing these messages excessively:
>>
>> db=postgres,user=postgres ERROR:  canceling statement due to user request
>>
>> Does Export cancel the SQLs? If not, why are we noticing these messages
>> excessively during the export operation? The load on the instance is minimal.
>
> I am not sure what exactly you mean by "export".  A pg_dump?
> But I am not aware of any operation that would cancel statements in other
> sessions.  Perhaps someone or something in your application sends cancel
> requests when a statement is running too long, and the concurrent export
> slows down the system.

What if the "export" is done on a read-only replica?

Could this be a "canceling statement due to conflict with recovery" in disguise?