Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6DE8D2E02E3 for ; Wed, 2 Jan 2008 12:31:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 86160-08 for ; Wed, 2 Jan 2008 12:31:16 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 323FA2E02CA for ; Wed, 2 Jan 2008 12:31:16 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m02GVFRl016133; Wed, 2 Jan 2008 11:31:15 -0500 (EST) To: Glyn Astill cc: pgsql-admin@postgresql.org Subject: Re: Shutting down warm standby server? " In-reply-to: <211337.29479.qm@web25815.mail.ukl.yahoo.com> References: <211337.29479.qm@web25815.mail.ukl.yahoo.com> Comments: In-reply-to Glyn Astill message dated "Wed, 02 Jan 2008 03:33:11 -0800" Date: Wed, 02 Jan 2008 11:31:15 -0500 Message-ID: <16132.1199291475@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/17 X-Sequence-Number: 27791 Glyn Astill writes: > I've setup a warm standby reading WAL files, however when I try to > shut it down I get the message "server does not shut down". > postgres@way5c:/mnt/archive$ /usr/local/pgsql/bin/pg_ctl stop -D > /data/postgres/ -m smart > waiting for server to shut > down............................................................... > failed > pg_ctl: server does not shut down Well, yeah, because you told it "-m smart" which is defined as "don't exit until all work is done". "-m fast" should work though, at least in 8.2.x --- if you are using something older, try "-m immediate". regards, tom lane