| From: | Dan Kogan <dan(at)iqtell(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Seemingly hanging checkpoint |
| Date: | 2013-06-19 10:46:36 |
| Message-ID: | 60B572D9298D944580F7D51195DD3080468902FE60@VMBX125.ihostexchange.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-06-19 11:02:14 | Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory |
| Previous Message | girish R G peetle | 2013-06-19 10:31:27 | Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory |