Olá Colegas ! Em meus estudos e tentativas de recovery (PITR) tenho encontrado a seguinte mensagem nos logs após um recovery supostamente bem sucedido:
-------------------------- 2015-11-09 18:44:34 AMST [38358]: [864-1] user=,db=,client= LOG: archive command failed with exit code 1 2015-11-09 18:44:34 AMST [38358]: [865-1] user=,db=,client= DETAIL: The failed archive command was: test ! -f /wals/00000002.history && cp pg_xlog/00000002.history /wals/00000002.history cp: cannot create regular file `/wals/00000002.history': No such file or directory 2015-11-09 18:44:35 AMST [38358]: [866-1] user=,db=,client= LOG: archive command failed with exit code 1 2015-11-09 18:44:35 AMST [38358]: [867-1] user=,db=,client= DETAIL: The failed archive command was: test ! -f /wals/00000002.history && cp pg_xlog/00000002.history /wals/00000002.history 2015-11-09 18:44:35 AMST [38358]: [868-1] user=,db=,client= WARNING: archiving transaction log file "00000002.history" failed too many times, will try again later cp: cannot create regular file `/wals/00000002.history': No such file or directory 2015-11-09 18:45:36 AMST [38358]: [869-1] user=,db=,client= LOG: archive command failed with exit code 1 2015-11-09 18:45:36 AMST [38358]: [870-1] user=,db=,client= DETAIL: The failed archive command was: test ! -f /wals/00000002.history && cp pg_xlog/00000002.history /wals/00000002.history cp: cannot create regular file `/wals/00000002.history': No such file or directory 2015-11-09 18:45:37 AMST [38358]: [871-1] user=,db=,client= LOG: archive command failed with exit code 1 2015-11-09 18:45:37 AMST [38358]: [872-1] user=,db=,client= DETAIL: The failed archive command was: test ! -f /wals/00000002.history && cp pg_xlog/00000002.history /wals/00000002.history cp: cannot create regular file `/wals/00000002.history': No such file or directory 2015-11-09 18:45:38 AMST [38358]: [873-1] user=,db=,client= LOG: archive command failed with exit code 1 2015-11-09 18:45:38 AMST [38358]: [874-1] user=,db=,client= DETAIL: The failed archive command was: test ! -f /wals/00000002.history && cp pg_xlog/00000002.history /wals/00000002.history 2015-11-09 18:45:38 AMST [38358]: [875-1] user=,db=,client= WARNING: archiving transaction log file "00000002.history" failed too many times, will try again later -------------------------- Digo bem sucedido porque quando observo manualmente o resultado do recovery, os dados estão perfeitamente integros. Como posso intepretar essa mensagem do log. É um erro ?! esta faltando algo ?! Tem algum procedimento ainda pedente ?! Obrigado pelas respostas. -- foobar
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
