Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 842872E3231 for ; Wed, 2 Jan 2008 12:50:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 45376-01 for ; Wed, 2 Jan 2008 12:50:55 -0400 (AST) Received: from n5.bullet.mail.re4.yahoo.com (n5.bullet.mail.re4.yahoo.com [206.190.56.24]) by postgresql.org (Postfix) with SMTP id 8E66F2E2FE8 for ; Wed, 2 Jan 2008 12:50:55 -0400 (AST) Received: from [68.142.237.87] by n5.bullet.re4.yahoo.com with NNFMP; 02 Jan 2008 16:50:54 -0000 Received: from [209.191.108.97] by t3.bullet.re3.yahoo.com with NNFMP; 02 Jan 2008 16:50:54 -0000 Received: from [209.191.119.163] by t4.bullet.mud.yahoo.com with NNFMP; 02 Jan 2008 16:50:53 -0000 Received: from [127.0.0.1] by omp102.mail.mud.yahoo.com with NNFMP; 02 Jan 2008 16:50:53 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 959998.97544.bm@omp102.mail.mud.yahoo.com Received: (qmail 91237 invoked by uid 60001); 2 Jan 2008 16:50:52 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=SttirLSY3Ghx870VjdJ0czo4esFaYpe08KITbK8qHn+BTBGW27niZJB8h+rE95HuXgSoXQY6M9X4jfrkKfTzcUuTDBAdwO0YSk4Bpl2FayVhLDOcCKXhM0ILF3RzPM5HnwDUX7A5PborZitn0M3AF1dICG0IDubCV9gOtKXC35k=; X-YMail-OSG: TtV06M8VM1kIl52gDDDubvcQrB1ug0_j650TmDhS41sCZfA4TJOZumjougtLeNpItA-- Received: from [83.166.184.142] by web25810.mail.ukl.yahoo.com via HTTP; Wed, 02 Jan 2008 08:50:52 PST Date: Wed, 2 Jan 2008 08:50:52 -0800 (PST) From: Glyn Astill Subject: Re: Shutting down warm standby server? " To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <16132.1199291475@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <549197.82850.qm@web25810.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/22 X-Sequence-Number: 27796 Aha.. excellent, thanks Tom! Sorry, I shall try to RTFM in the future. --- Tom Lane wrote: > 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire > to > choose an index scan if your joining column's datatypes do > not > match > __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com