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