Jota,
>Você viu este erro acima? Eu vi a msg de erro, mas os arquivos foram transferidos. >Ambos são esta mesma máquina? >ervidores diferentes? As máquinas são distintas ! >Onde está a configuração do seu restore_command? Neste caso eu naõ estou utilizando, poi é por stream e utilizo o pgbasebackup ! É obrigatório o restore_commad ? >Em que momento você cria pg_xlog/archive_status? >Está deixando o banco criar para você? Eu deixo o banco criar. Interessante que agora após eu transferir todo o conteúdo de pg_xlog do ser servidor1 para o pg_xlog do servidor2 o banco inicia, mas ele ja entra em estado de recovery ! não visualizo os processos walsender e walreceiver ! -bash-4.1$ tail -100 postgresql-Thu.log LOG: database system was interrupted; last known up at 2012-07-12 13:15:00 BRT LOG: entering standby mode LOG: trigger file found: /tmp/arquivo_gatilho.pgsql LOG: invalid checkpoint record FATAL: could not locate required checkpoint record HINT: If you are not restoring from a backup, try removing the file "/data/9.1/backup_label". LOG: startup process (PID 7670) exited with exit code 1 LOG: aborting startup due to startup process failure LOG: database system was interrupted; last known up at 2012-07-12 13:15:00 BRT LOG: entering standby mode LOG: trigger file found: /tmp/arquivo_gatilho.pgsql LOG: invalid primary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 7682) was terminated by signal 6: Aborted LOG: aborting startup due to startup process failure LOG: database system was interrupted; last known up at 2012-07-12 13:15:00 BRT LOG: entering standby mode LOG: consistent recovery state reached at 0/420000B0 LOG: redo starts at 0/42000020 LOG: unexpected pageaddr 0/3B000000 in log file 0, segment 67, offset 0 LOG: trigger file found: /tmp/arquivo_gatilho.pgsql LOG: redo done at 0/420000D8 LOG: selected new timeline ID: 2 LOG: database system is ready to accept read only connections LOG: archive recovery complete LOG: database system is ready to accept connections LOG: autovacuum launcher started -- Antonio Abner Junior - AJ
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
