X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C0E8D53330 for ; Sun, 24 Apr 2005 09:53:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54825-08 for ; Sun, 24 Apr 2005 12:53:16 +0000 (GMT) Received: from exit1.i-55.com (exit1.i-55.com [208.231.96.22]) by svr1.postgresql.org (Postfix) with ESMTP id 61FCB538B1 for ; Sun, 24 Apr 2005 09:53:03 -0300 (ADT) Received: from simpsonnew (dsl-209-205-186-247.i-55.com [209.205.186.247]) by exit1.i-55.com (8.11.7/8.11.4) with SMTP id j3OCr7306777 for ; Sun, 24 Apr 2005 07:53:07 -0500 From: "Simpson" To: Subject: postmaster stop hangs Date: Sun, 24 Apr 2005 07:54:50 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.07 tagged_above=0 required=5 tests=AWL, DNS_FROM_AHBL_RHSBL X-Spam-Level: X-Archive-Number: 200504/352 X-Sequence-Number: 17365 Greetings, Running /etc/init.d/postgresql stop results in: Stopping postgresql service: [FAILED] I ran an strace on "/usr/local/pgsql/bin/pg_ctl stop -D /data/pgsql/data -s -m fast" and it is sending a SIGINT to processid 5676 Here is a ps of the currently running instance: postgres 5671 1 0 02:32 pts/0 00:00:00 /usr/local/pgsql/bin/postmaster -D /data/pgsql/data postgres 5674 5671 0 02:32 pts/0 00:00:00 postgres: writer process postgres 5675 5671 0 02:32 pts/0 00:00:00 postgres: stats buffer process postgres 5676 5675 0 02:32 pts/0 00:00:00 postgres: stats collector process In this case, shouldn't it be sending a SIGTERM to 5671? If I manually send a SIGINT or a SIGTERM to the postmaster (5671 in this case), postgres obediently shuts down. 5676 is in the */data/postmaster.pid Thanks for any help, Drew. postgresql 8.0.2 Linux xxx 2.6.9-5.0.3.EL #1 Sat Feb 19 18:26:49 CST 2005 i686 i686 i386 GNU/Linux