Muito esclarecedor Sebastian. Muito grato! Farei mais testes para validar e continuar meus estudos, obrigado a todos !
Em 10 de novembro de 2015 08:39, Sebastian Webber <[email protected]> escreveu: > > > 2015-11-09 19:58 GMT-02:00 Franklin Anderson de Oliveira Souza < > [email protected]>: > >> Olá Colegas ! >> > > > E aí Franklink, tudo bem? > > >> >> 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. >> > > > > Citado na doc[1]: > > ...You may also see an error message at the start of recovery for a file > named something like 00000001.history. This is also normal and does not > indicate a problem in simple recovery situations; see Section 24.3.5 > <http://www.postgresql.org/docs/current/static/continuous-archiving.html#BACKUP-TIMELINES> > for > discussion. > > > Em outras palavras: relaxa. > > Achei um tutorial bem legal que fala do comportamento do PITR no > PostgreSQL[2]. Dá uma olhada e ve se ajuda a fixar a idéia. > > Abração! > > > [1] > http://www.postgresql.org/docs/current/static/continuous-archiving.html > [2] > http://raghavt.blogspot.com.br/2014/04/while-performing-pitr-would-it-be_6.html > > -- > Sebastian Webber > http://swebber.me > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > -- foobar
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
