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 |
