Prezados,

 

Somos iniciantes no Postgres, bem como nesta lista.

Estamos realizando um restore PITR e ocorre o erro abaixo:

 

2012-10-16 07:58:12 BRT[21835]: [135-1] @  0:LOG:  restored log file "000000010000006400000012" from archive
2012-10-16 07:58:14 BRT[21835]: [136-1] @  0:LOG:  restored log file "000000010000006400000013" from archive
2012-10-16 07:58:15 BRT[21835]: [137-1] @  0:LOG:  restored log file "000000010000006400000014" from archive
2012-10-16 07:58:17 BRT[21835]: [138-1] @  0:LOG:  restored log file "000000010000006400000015" from archive
2012-10-16 07:58:20 BRT[21835]: [139-1] @  0:LOG:  restored log file "000000010000006400000016" from archive
2012-10-16 07:58:23 BRT[21835]: [140-1] @  0:LOG:  recovery stopping before commit of transaction 5446843, time 2012-10-01 17:01:12.21663-03
2012-10-16 07:58:23 BRT[21835]: [141-1] @  0:LOG:  redo done at 64/166F1060
2012-10-16 07:58:23 BRT[21835]: [142-1] @  0:LOG:  last completed transaction was at log time 2012-10-01 16:58:44.608024-03
cp: cannot stat `/backup/backup/waltmp/00000002.history': No such file or directory
2012-10-16 07:58:23 BRT[21835]: [143-1] @  0:LOG:  selected new timeline ID: 2
cp: cannot stat `/backup/backup/waltmp/00000001.history': No such file or directory
2012-10-16 07:58:23 BRT[21835]: [144-1] @  0:LOG:  archive recovery complete
2012-10-16 07:58:23 BRT[21839]: [1-1] @  0:LOG:  checkpoint starting: end-of-recovery immediate wait
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.
2012-10-16 07:58:23 BRT[21829]: [3-1] @  0:LOG:  startup process (PID 21835) exited with exit code 1
2012-10-16 07:58:23 BRT[21829]: [4-1] @  0:LOG:  terminating any other active server processes

O que podemos estar fazendo de errado, para ocorrer esse fatal erro?

 

Desde já agradecemos.


Atenciosamente,

===================================
Silvio Araújo
Analista de Suporte
Unidade de Banco de Dados
Geprod - Gerência de Produção
Diretoria de Informática
===================================

_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a