Hello,

It seems that a checkpoint started but didn't finish last night on our db 
server.
We are using version 9.2.4.

This is from the postgres log:

2013-06-19 03:38:49 UTC [32252]: [19-1] [] LOG:  checkpoint starting: time
2013-06-19 03:55:01 UTC [32252]: [20-1] [] LOG:  checkpoint complete: wrote 
25408 buffers (4.8%); 0 transaction log file(s) added, 0 removed, 89 recycled; 
write=971.925 s, sync=0.495 s, total=972.440 s; sync files=901, longest=0.021 
s, average=0.000 s

2013-06-19 04:23:49 UTC [32252]: [21-1] [] LOG:  checkpoint starting: time


Seems like the checkpoint that started at 4:23 UTC did not complete.

Any advice what we can do to complete the checkpoint is appreciated.

Thanks,
Dan Kogan

Reply via email to