Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id AAD139FB855 for ; Thu, 11 Oct 2007 14:04:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 76079-10 for ; Thu, 11 Oct 2007 14:03:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 844699FB546 for ; Thu, 11 Oct 2007 14:03:53 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so484571ugf for ; Thu, 11 Oct 2007 10:03:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=c8qId7GACBCy4fa93noCskKHlknnPLK6NZ+MYPg2cB4=; b=fieVCJyBXgAAanY6hb+09OtYYlwkHDxF3UZiVnJHkCHW2F62wE/09DLgwRKbShPShOI79o0gJFHeGhKKszEdr4142rTgGrhLflegsKiD6Rroc4YFHyRq0Bx2POOPC9cgY+g/lHQiNCch6b/4n1kcUbgFFLAlxVsKNrUR3662uq4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZJP+oIFcgiJJGWWjW36vnLFxLqpEtItgXjUwFJ4C7vH0ytHP/jYW42MHq86hTbXref182ECJovBrHZSOf5fSZHdM3U91n+YkrgyhI4b4mPCm9VqfxImUpdeqI2k++NoRY+wx3AMYxuzwrGvd1uZ8LX2LZjzfUsVYOSe886TaAL0= Received: by 10.66.220.17 with SMTP id s17mr3371785ugg.1192122231533; Thu, 11 Oct 2007 10:03:51 -0700 (PDT) Received: by 10.67.29.6 with HTTP; Thu, 11 Oct 2007 10:03:51 -0700 (PDT) Message-ID: Date: Thu, 11 Oct 2007 12:03:51 -0500 From: "Scott Marlowe" To: "Tena Sakai" Subject: Re: failure on 'pg_ctl stop' command Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/97 X-Sequence-Number: 27011 On 10/11/07, Tena Sakai wrote: > > > > Hi Everybody, > > I had a failure on stopping postgres. > The command I issued was: > >> pg_ctl stop -m s > > and its response was: > >> waiting for server to shut > down............................................................... > failed > >> pg_ctl: server does not shut down > > I repeated the same command and the response was identical. > I proceeded to issue: > >> pg_ctl stop -m f > > and this time it came back with: > >> waiting for server to shut down.... done > >> server stopped > > Would somebody please tell me what this means? > Is it indicative of some trouble? What can/Should > I do to remedy the situation? Normally this means that you have clients connected to the db while it's trying to shut down. On the server, run ps ax|grep postgres and look for a client connected in IDLE state. You can either disconnect all the clients, or use -m f, which will disconnect them for you.