Re: ERROR: canceling query due to user request - Mailing list pgsql-admin

From Tom Lane
Subject Re: ERROR: canceling query due to user request
Date
Msg-id 10665.1071857466@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: canceling query due to user request  ("Iain" <iain@mst.co.jp>)
List pgsql-admin
"Iain" <iain@mst.co.jp> writes:
> This is typical of the errors I got:
> pg_dump: ERROR:  canceling query due to user request

If you didn't actually do anything to cancel the query, then this
indicates that something is sending SIGINT signals to the backend
process.  I'd bet on a "ulimit" or equivalent resource-limit setting
being tripped.  Check what conditions the postmaster is being started
under --- generally, you do not want *any* active ulimit restrictions
on the server processes.

            regards, tom lane

pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Help needed Please !!!!!incremental backups possible in
Next
From: Tom Lane
Date:
Subject: Re: FATAL: unrecognized configuration parameter "show_statement_stats"