Re: Postgresql not accessible, recovering

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux