"Carlos Oliva" <carlos(at)pbsinet(dot)com> writes:
> We are getting the following error message whe we run "pg_dump -Ft <database
> name> > database.tar":
> pg_dump: ERROR: canceling query due to user request
This implies that something sent SIGINT to the backend process.
We've heard some reports that suggest that some platforms send SIGINT
when a soft resource consumption limit is hit (too much process runtime
or I/O or something). Look around for something of that description,
particularly if the limit settings were changed recently.
regards, tom lane