Re: Does export operation cancel SQLs?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Does export operation cancel SQLs?
Дата
Msg-id CAKFQuwbRW77=4zboZfOv3_E7ct-36gNvnEfk38GhPbCUcNR5Qw@mail.gmail.com
обсуждение исходный текст
Ответ на Does export operation cancel SQLs?  (Siraj G <tosiraj.g@gmail.com>)
Ответы Re: Does export operation cancel SQLs?
Список pgsql-admin
On Wednesday, February 19, 2025, Siraj G <tosiraj.g@gmail.com> wrote:
Hello Experts!

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

It says “user request”.  I’d advise figuring out what was cancelled and what “user” did so.  Probably DDL commands failing to get exclusive locks.

David J.

В списке pgsql-admin по дате отправления: