Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 12FA42E0152 for ; Wed, 2 Jan 2008 07:33:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 34716-06 for ; Wed, 2 Jan 2008 07:33:14 -0400 (AST) Received: from n7.bullet.mud.yahoo.com (n7.bullet.mud.yahoo.com [216.252.100.58]) by postgresql.org (Postfix) with SMTP id 1EE902E012E for ; Wed, 2 Jan 2008 07:33:13 -0400 (AST) Received: from [209.191.108.96] by n7.bullet.mud.yahoo.com with NNFMP; 02 Jan 2008 11:33:12 -0000 Received: from [209.191.119.183] by t3.bullet.mud.yahoo.com with NNFMP; 02 Jan 2008 11:33:12 -0000 Received: from [127.0.0.1] by omp106.mail.mud.yahoo.com with NNFMP; 02 Jan 2008 11:33:12 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 654197.98368.bm@omp106.mail.mud.yahoo.com Received: (qmail 30250 invoked by uid 60001); 2 Jan 2008 11:33:11 -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:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Cz3cTTAfn0/ZygKGBQgohT1qZrvo+F29UQhwlb4zjxMkd1tAKi/qYpw9pSWrgc+EJ+yDz8MGYWHIykV5YBTeY6U96r3wu94WdEV3o6hJXTvmFNOeLsVauKr8r00q5mDudJqaVTNY3wohFfOCJQgD3ARMcWnH6XDmryBIZpni6N0=; X-YMail-OSG: EM4cPmgVM1mFIdMC4N.GJbtgbiaOmnkm3y5wxwUDrc_YaaoFhToFS8X.XktYeBa_NRjulNdR32ZeuCznR.02O427mreAi79KksBMQ.SzsSLFJuBpaPW75GYwN5I- Received: from [83.166.184.142] by web25815.mail.ukl.yahoo.com via HTTP; Wed, 02 Jan 2008 03:33:11 PST Date: Wed, 2 Jan 2008 03:33:11 -0800 (PST) From: Glyn Astill Subject: Shutting down warm standby server? " To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <211337.29479.qm@web25815.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/8 X-Sequence-Number: 27782 Hi people, 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". Can someone help please, I presume it has something to do with the server being busy waiting for the next WAL file? What is the correct way to shut down a server reading WALs? The command line output is below: 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 If I do a ps -ax: 7956 pts/0 S 0:00 /usr/local/pgsql/bin/postgres -D /data/postgres/ 7957 ? Ss 0:10 postgres: startup process 7371 ? S 0:00 /bin/bash /data/postgres/restore.sh /mnt/archive/000000010000001A000000A8 pg_xlog/RECOVERYXLOG 1160 ? S 0:00 sleep 1 1161 pts/0 R+ 0:00 ps -ax it looks like it's waikting for the next WAL file. __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com