Oi Euler,
Obrigado pelo retorno.
Segue mensagens do log antes do restore iniciar:
2012-10-16 07:55:38 BRT[21835]: [1-1] @ 0:LOG: database system was interrupted; last known up at 2012-10-01 01
:15:34 BRT
2012-10-16 07:55:38 BRT[21835]: [2-1] @ 0:LOG: creating missing WAL directory "pg_xlog/archive_status"
2012-10-16 07:55:38 BRT[21835]: [3-1] @ 0:LOG: starting archive recovery
2012-10-16 07:55:38 BRT[21835]: [4-1] @ 0:LOG: restore_command = 'cp /backup/backup/waltmp/%f %p'
2012-10-16 07:55:38 BRT[21835]: [5-1] @ 0:LOG: recovery_target_time = '2012-10-01 17:00:00-03'
cp: cannot stat `/backup/backup/waltmp/00000001.history': No such file or directory
2012-10-16 07:55:38 BRT[21835]: [6-1] @ 0:LOG: restored log file "00000001000000630000009A.00000020.backup" fr
om archive
2012-10-16 07:55:38 BRT[21835]: [7-1] @ 0:LOG: restored log file "00000001000000630000009A" from archive
2012-10-16 07:55:38 BRT[21835]: [8-1] @ 0:LOG: automatic recovery in progress
2012-10-16 07:55:38 BRT[21835]: [9-1] @ 0:LOG: redo starts at 63/9A000068, consistency will be reached at 63/9
A881CC8
2012-10-16 07:55:38 BRT[21835]: [10-1] @ 0:LOG: file "pg_clog/0005" doesn't exist, reading as zeroes
2012-10-16 07:55:38 BRT[21835]: [11-1] @ 0:CONTEXT: xlog redo commit: 2012-10-01 00:08:39.739283-03
2012-10-16 07:55:39 BRT[21835]: [12-1] @ 0:LOG: consistent recovery state reached
2012-10-16 07:55:39 BRT[21835]: [13-1] @ 0:LOG: restored log file "00000001000000630000009B" from archive
2012-10-16 07:55:40 BRT[21835]: [14-1] @ 0:LOG: restored log file "00000001000000630000009C" from archive
2012-10-16 07:55:40 BRT[21835]: [15-1] @ 0:LOG: restored log file "00000001000000630000009D" from archive
2012-10-16 07:55:42 BRT[21835]: [16-1] @ 0:LOG: restored log file "00000001000000630000009E" from archive
2012-10-16 07:55:42 BRT[21835]: [17-1] @ 0:LOG: file "pg_multixact/offsets/0000" doesn't exist, reading as zer
oes
2012-10-16 07:55:42 BRT[21835]: [18-1] @ 0:CONTEXT: xlog redo create multixact 15281 offset 31187: 5411041 541
1042
2012-10-16 07:55:42 BRT[21835]: [19-1] @ 0:LOG: file "pg_multixact/members/0000" doesn't exist, reading as zer
oes
2012-10-16 07:55:42 BRT[21835]: [20-1] @ 0:CONTEXT: xlog redo create multixact 15281 offset 31187: 5411041 541
1042
2012-10-16 07:55:43 BRT[21835]: [21-1] @ 0:LOG: restored log file "00000001000000630000009F" from archive
2012-10-16 07:55:44 BRT[21835]: [22-1] @ 0:LOG: restored log file "0000000100000063000000A0" from archive
2012-10-16 07:55:45 BRT[21835]: [23-1] @ 0:LOG: restored log file "0000000100000063000000A1" from archive
2012-10-16 07:55:46 BRT[21835]: [24-1] @ 0:LOG: restored log file "0000000100000063000000A2" from archive
2012-10-16 07:55:48 BRT[21835]: [25-1] @ 0:LOG: restored log file "0000000100000063000000A3" from archive
2012-10-16 07:55:49 BRT[21835]: [26-1] @ 0:LOG: restored log file "0000000100000063000000A4" from archive
2012-10-16 07:55:50 BRT[21835]: [27-1] @ 0:LOG: restored log file "0000000100000063000000A5" from archive
Atenciosamente,
===================================
Silvio Araújo
Analista de Suporte
Unidade de Banco de Dados
Geprod - Gerência de Produção
Diretoria de Informática
===================================
Em 16/10/2012 às 11:11 horas, [email protected] escreveu:
On 16-10-2012 09:01, Silvio Araujo da Silva wrote: > 2012-10-16 07:58:23 BRT[21835]: [145-1] @ 0:FATAL: checkpoint request failed > 2012-10-16 07:58:23 BRT[21835]: [146-1] @ 0:HINT: Consult recent messages in > the server log for details. > É um erro um tanto estranho. Qual é a versão do PostgreSQL? Deve haver uma outra mensagem de erro acima das que você mostrou (indicando porque o checkpoint falhou), não? -- Euler Taveira de Oliveira - Timbira www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento _______________________________________________ pgbr-geral mailing list [email protected] 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
