Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VjTfQ-0005WP-27 for pgsql-admin@arkaria.postgresql.org; Thu, 21 Nov 2013 12:47:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VjTfP-0005lB-HR for pgsql-admin@arkaria.postgresql.org; Thu, 21 Nov 2013 12:47:31 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VjTfO-0005kV-Am for pgsql-admin@postgresql.org; Thu, 21 Nov 2013 12:47:30 +0000 Received: from hub.ringways.co.uk ([88.211.105.30] helo=mail.ringways.co.uk) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VjTfH-0007E0-G9 for pgsql-admin@postgresql.org; Thu, 21 Nov 2013 12:47:29 +0000 Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.69) (envelope-from ) id 1VjTfE-0002c2-PY for pgsql-admin@postgresql.org; Thu, 21 Nov 2013 12:47:20 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: Re: Postgresql not accessible, recovering Date: Thu, 21 Nov 2013 12:47:20 +0000 User-Agent: KMail/1.9.10 References: <201311191108.18620.gary.stainburn@ringways.co.uk> <201311191439.59390.gary.stainburn@ringways.co.uk> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201311211247.20613.gary.stainburn@ringways.co.uk> X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Wednesday 20 November 2013 10:57:13 Luca Ferrari wrote: > On Tue, Nov 19, 2013 at 3:39 PM, Gary Stainburn > > wrote: > > On Tuesday 19 November 2013 14:25:44 bricklen wrote: > > > > LOG: received smart shutdown request > > LOG: shutting down > > LOG: database system is shut down > > LOG: database system was shut down in recovery at 2013-11-19 10:22:59 > > GMT LOG: database system was not properly shut down; automatic recovery > > in progress > > Are you shutting down the database while recovery is in progress or is > there any tool that is doing that for you? I mean, the recovery could > be taking so long because something is kicking it away before it is > finished? > For what I know recovery should be kind of proprotional to the > checkpoint configurations, have you changed such settings to get very > high windows over checkpoints? > > Luca That may well have been from when I tried restarting the Postgresql service. Thankfully the recovery finished at 10:40 yesterday and normal service has resumed. Thanks to all who responded. Gary -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin