On Wednesday 20 November 2013 10:57:13 Luca Ferrari wrote: > On Tue, Nov 19, 2013 at 3:39 PM, Gary Stainburn > > <gary.stainburn@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
