Thread: Seemingly hanging checkpoint

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