Franklin, boa noite Para voltar um PITR altero o arquivo postgresql.conf e desativo o archive_command e outros parâmetros, caso o servidor seja diferente do original. Creio que você está voltando o PITR em outro servidor, pois no log aparece o erro "No such file or directory". Nesse caso acho que o diretório não existe ou o Postgres não tem permissão no diretório. Após todo o sucesso de recuperação do servidor reativo o archive.
Att, Em 9 de novembro de 2015 21:29, Franklin Anderson de Oliveira Souza < frankli...@gmail.com> escreveu: > Olá Ronaldo !! > > Está sim ativado, será esse o motivo !? > > > Em segunda-feira, 9 de novembro de 2015, Ronaldo Bernardes Pereira < > ronaldobernar...@gmail.com> escreveu: > >> Franklin, boa noite >> >> No arquivo postgresql. conf antes de você iniciar o recovery, o parâmetro >> archive_command está ativado? >> >> >> 2015-11-09 19:58 GMT-02:00 Franklin Anderson de Oliveira Souza < >> frankli...@gmail.com>: >> >>> 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 >>> pgbr-geral@listas.postgresql.org.br >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >> >> > > -- > Enviado do Gmail para celular > > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
