From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgresql not accessible, recovering |
Date: | 2013-11-21 12:47:20 |
Message-ID: | 201311211247.20613.gary.stainburn@ringways.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wednesday 20 November 2013 10:57:13 Luca Ferrari wrote:
> On Tue, Nov 19, 2013 at 3:39 PM, Gary Stainburn
>
> <gary(dot)stainburn(at)ringways(dot)co(dot)uk> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Payal Singh | 2013-11-21 15:08:53 | Re: Archive fails due to missing backup file |
Previous Message | Robert Burgholzer | 2013-11-21 12:34:39 | Archive fails due to missing backup file |