Boa tarde a todos !! Estou com uma base em modo stand-by e tudo ocorre de forma esperada. Os arquivos wal são gerados pelo master e incorporados pelo slave sem problemas. O meu problema é qdo eu crio o arquivo de trigger para o banco entrar em produção. No log do recovery recebo a informação de que uns arquivos .history não foram localizados. O banco até sobe, mas não sei onde ir buscar estes arquivos requeridos.
E uma outra dúvida ... Os arquivos wal copiados do master para o slave são só aqueles que estão cheios e que foram copiados pelo archive_command. E o arquivo atual ??? Como eu devo fazer para que esse arquivo também seja processado pelo slave ??? Banco na versão 8.4.4 SO Freebsd Obrigado André Vejam as mensagens do log : ... WAL file not present yet. Checking for trigger file... WAL file not present yet. Checking for trigger file... WAL file not present yet. Checking for trigger file... trigger file found: smart failover Trigger file : /tmp/pgsql.trigger.5437 Waiting for WAL file : 0000000100000002000000AB WAL file path : /dados/wal/hemo/0000000100000002000000AB Restoring to : pg_xlog/RECOVERYXLOG Sleep interval : 5 seconds Max wait interval : 0 forever Command for restore : cp "/dados/wal/hemo/0000000100000002000000AB" "pg_xlog/RECOVERYXLOG" Keep archive history : 000000000000000000000000 and later trigger file found: smart failover running restore : OK Trigger file : /tmp/pgsql.trigger.5437 Waiting for WAL file : 00000002.history WAL file path : /dados/wal/hemo/00000002.history Restoring to : pg_xlog/RECOVERYHISTORY Sleep interval : 5 seconds Max wait interval : 0 forever Command for restore : cp "/dados/wal/hemo/00000002.history" "pg_xlog/RECOVERYHISTORY" Keep archive history : 000000000000000000000000 and later running restore :cp: /dados/wal/hemo/00000002.history: No such file or directory cp: /dados/wal/hemo/00000002.history: No such file or directory cp: /dados/wal/hemo/00000002.history: No such file or directory cp: /dados/wal/hemo/00000002.history: No such file or directory not restored history file not found Trigger file : /tmp/pgsql.trigger.5437 Waiting for WAL file : 00000003.history WAL file path : /dados/wal/hemo/00000003.history Restoring to : pg_xlog/RECOVERYHISTORY Sleep interval : 5 seconds Max wait interval : 0 forever Command for restore : cp "/dados/wal/hemo/00000003.history" "pg_xlog/RECOVERYHISTORY" Keep archive history : 000000000000000000000000 and later running restore :cp: /dados/wal/hemo/00000003.history: No such file or directory cp: /dados/wal/hemo/00000003.history: No such file or directory cp: /dados/wal/hemo/00000003.history: No such file or directory cp: /dados/wal/hemo/00000003.history: No such file or directory not restored history file not found Trigger file : /tmp/pgsql.trigger.5437 Waiting for WAL file : 00000001.history WAL file path : /dados/wal/hemo/00000001.history Restoring to : pg_xlog/RECOVERYHISTORY Sleep interval : 5 seconds Max wait interval : 0 forever Command for restore : cp "/dados/wal/hemo/00000001.history" "pg_xlog/RECOVERYHISTORY" Keep archive history : 000000000000000000000000 and later running restore :cp: /dados/wal/hemo/00000001.history: No such file or directory cp: /dados/wal/hemo/00000001.history: No such file or directory cp: /dados/wal/hemo/00000001.history: No such file or directory cp: /dados/wal/hemo/00000001.history: No such file or directory not restored history file not found _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
