X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A8802D1B4B0 for ; Fri, 19 Dec 2003 18:15:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48614-04 for ; Fri, 19 Dec 2003 14:14:51 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id D777ED1B495 for ; Fri, 19 Dec 2003 14:11:10 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBJIB619010666; Fri, 19 Dec 2003 13:11:06 -0500 (EST) To: "Iain" Cc: pgsql-admin@postgresql.org Subject: Re: ERROR: canceling query due to user request In-reply-to: <007f01c3c548$aa0aaf50$7201a8c0@mst1x5r347kymb> References: <007f01c3c548$aa0aaf50$7201a8c0@mst1x5r347kymb> Comments: In-reply-to "Iain" message dated "Thu, 18 Dec 2003 18:23:57 +0900" Date: Fri, 19 Dec 2003 13:11:06 -0500 Message-ID: <10665.1071857466@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/278 X-Sequence-Number: 11784 "Iain" 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