"Iain" <iain(at)mst(dot)co(dot)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