Veja a queda ocorrida em 06/01 : TRANSFACIL07/root:/p01/pgdata/pg_log > tail -2500 postgresql-2015-01-05_000000.log | grep checkpoint 2015-01-05 22:19:15 GMT+3 [12058648] - [] [34981-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:20:58 GMT+3 [12058648] - [] [34982-1] db=,user= LOG: checkpoint complete: wrote 65565 buffers (5.0%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=103.328 s, sync=0.037 s, total=103.461 s; sync files=207, longest=0.012 s, average=0.000 s 2015-01-05 22:22:13 GMT+3 [12058648] - [] [34983-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:23:59 GMT+3 [12058648] - [] [34984-1] db=,user= LOG: checkpoint complete: wrote 66421 buffers (5.1%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=105.647 s, sync=0.155 s, total=105.924 s; sync files=244, longest=0.126 s, average=0.000 s 2015-01-05 22:25:21 GMT+3 [12058648] - [] [34985-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:27:05 GMT+3 [12058648] - [] [34986-1] db=,user= LOG: checkpoint complete: wrote 74550 buffers (5.7%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=103.882 s, sync=0.033 s, total=104.030 s; sync files=226, longest=0.006 s, average=0.000 s 2015-01-05 22:28:04 GMT+3 [12058648] - [] [34987-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:29:55 GMT+3 [12058648] - [] [34988-1] db=,user= LOG: checkpoint complete: wrote 68313 buffers (5.2%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=110.235 s, sync=0.067 s, total=110.402 s; sync files=181, longest=0.027 s, average=0.000 s 2015-01-05 22:31:18 GMT+3 [12058648] - [] [34989-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:32:53 GMT+3 [12058648] - [] [34990-1] db=,user= LOG: checkpoint complete: wrote 82952 buffers (6.3%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=94.370 s, sync=0.081 s, total=94.576 s; sync files=234, longest=0.038 s, average=0.000 s 2015-01-05 22:34:03 GMT+3 [12058648] - [] [34991-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:35:50 GMT+3 [12058648] - [] [34992-1] db=,user= LOG: checkpoint complete: wrote 88543 buffers (6.8%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=106.917 s, sync=0.029 s, total=107.043 s; sync files=206, longest=0.006 s, average=0.000 s 2015-01-05 22:37:02 GMT+3 [12058648] - [] [34993-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:38:42 GMT+3 [12058648] - [] [34994-1] db=,user= LOG: checkpoint complete: wrote 73611 buffers (5.6%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=99.483 s, sync=0.116 s, total=99.704 s; sync files=222, longest=0.066 s, average=0.000 s 2015-01-05 22:39:55 GMT+3 [12058648] - [] [34995-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 22:49:59 GMT+3 [12058648] - [] [34996-1] db=,user= LOG: checkpoint complete: wrote 76188 buffers (5.8%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=601.571 s, sync=0.361 s, total=603.108 s; sync files=213, longest=0.171 s, average=0.001 s 2015-01-05 22:49:59 GMT+3 [12058648] - [] [34997-1] db=,user= LOG: checkpoint starting: xlog 2015-01-05 23:09:14 GMT+3 [12058648] - [] [34998-1] db=,user= LOG: checkpoint complete: wrote 149081 buffers (11.4%); 0 transaction log file(s) added, 0 removed, 30 recycled; write=1154.035 s, sync=0.457 s, total=1155.299 s; sync files=264, longest=0.106 s, average=0.001 s 2015-01-05 23:09:14 GMT+3 [12058648] - [] [34999-1] db=,user= LOG: checkpoint starting: xlog time 2015-01-05 23:37:56 GMT+3 [12058648] - [] [35000-1] db=,user= LOG: checkpoint complete: wrote 189340 buffers (14.4%); 0 transaction log file(s) added, 9 removed, 61 recycled; write=1721.097 s, sync=0.610 s, total=1722.135 s; sync files=296, longest=0.297 s, average=0.002 s 2015-01-05 23:37:56 GMT+3 [12058648] - [] [35001-1] db=,user= LOG: checkpoint starting: immediate force wait xlog time TRANSFACIL07/root:/p01/pgdata/pg_log > cat postgresql-2015-01-06_000000.log | grep checkpoint 2015-01-06 00:14:56 GMT+3 [27263200] - [] [11-1] db=,user= LOG: checkpoint starting: end-of-recovery immediate TRANSFACIL07/root:/p01/pgdata/pg_log > cat postgresql-2015-01-06_003019.log | grep checkpoint | pg 2015-01-06 00:59:13 GMT+3 [27263200] - [] [12-1] db=,user= LOG: checkpoint complete: wrote 900808 buffers (68.7%); 0 transaction log file(s) added, 123 removed 2015-01-06 01:00:39 GMT+3 [27263202] - [] [1-1] db=,user= LOG: checkpoint starting: xlog 2015-01-06 01:03:51 GMT+3 [27263202] - [] [2-1] db=,user= LOG: checkpoint complete: wrote 186836 buffers (14.3%); 0 transaction log file(s) added, 392 removed, 2015-01-06 01:03:51 GMT+3 [27263202] - [] [3-1] db=,user= LOG: checkpoint starting: xlog 2015-01-06 01:05:43 GMT+3 [27263202] - [] [4-1] db=,user= LOG: checkpoint complete: wrote 121050 buffers (9.2%); 0 transaction log file(s) added, 9 removed, 21 2015-01-06 01:09:53 GMT+3 [27263202] - [] [5-1] db=,user= LOG: checkpoint starting: xlog 2015-01-06 01:20:23 GMT+3 [27263202] - [] [6-1] db=,user= LOG: checkpoint complete: wrote 83269 buffers (6.4%); 0 transaction log file(s) added, 27 removed, 27
Logo TRANSFACIL Antônio Galery Sistema Central Tel.: 31 3248-7026 E-mail: [email protected] Acesse: www.transfacil.com.br Esta mensagem, incluindo seus anexos, pode conter informações privilegiadas e/ou de caráter confidencial, não podendo ser retransmitida sem autorização do remetente. Se você não é o destinatário ou pessoa autorizada a recebê-la, informamos que o seu uso, divulgacão, cópia ou arquivamento sao proibidos. Portanto, se você recebeu esta mensagem por engano, por favor, nos informe respondendo imediatamente a este e-mail e em seguida apague-a. Antes de imprimir, pense em seu compromisso com o Meio Ambiente. ----- Mensagem original ----- De: "Flavio Henrique Araque Gurgel" <[email protected]> Para: [email protected] Enviadas: Sexta-feira, 16 de janeiro de 2015 14:11:00 Assunto: Re: [pgbr-geral] checkpoint begin On 16-01-2015 17:04, Matheus de Oliveira wrote: > 2015-01-16 01:37:32 GMT+3 [27263202] - [] [14322-1] db=,user= LOG: > checkpoint starting: xlog > 2015-01-16 01:44:10 GMT+3 [44826800] - [] [9-1] db=,user= LOG: > checkpoint starting: end-of-recovery immediate O banco caiu entre estas duas linhas, provavelmente. O que havia no log entre elas? []s Flavio Gurgel _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
