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 A3EFDD1B477 for ; Wed, 24 Dec 2003 02:11:23 +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 81672-03 for ; Tue, 23 Dec 2003 22:10:38 -0400 (AST) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id B6916D1B471 for ; Tue, 23 Dec 2003 22:10:33 -0400 (AST) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id hBO1xQJ28240; Wed, 24 Dec 2003 10:59:26 +0900 Message-ID: <005201c3c9c3$1b5ecff0$7201a8c0@mst1x5r347kymb> From: "Iain" To: "Tom Lane" Cc: References: <007f01c3c548$aa0aaf50$7201a8c0@mst1x5r347kymb> <10665.1071857466@sss.pgh.pa.us> Subject: Re: ERROR: canceling query due to user request Date: Wed, 24 Dec 2003 11:10:30 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/305 X-Sequence-Number: 11811 Hi Tom, I agree with your assessment of this. I'm no expert on Linux, and I'm new to Postgres but I'm learning. I hope to have a chance to play with and test these kinds of configuration settings before the system goes live. Unfortunately there is no plan for a test environment that is comparable to the production environment. By the way, I've been using 7.4 for a little while now (in development) and my feeling is that the DB has matured considerably since the previous version I used which was 7.1. It's looking good so far. Regards Iain ----- Original Message ----- From: "Tom Lane" To: "Iain" Cc: Sent: Saturday, December 20, 2003 3:11 AM Subject: Re: [ADMIN] ERROR: canceling query due to user request > "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