2009/4/23 paulo matadr <[email protected]>:
> Bom dia pessoal,
> nossa base de producao nao starta,quando agente tenta levantar o banco ele
> entra em modo recover,consume toda a memoria da maquina ate travar por
> kernel panic.
> com isso o servidor para.
> esse é o ultimo log  gerado pelo postgres
>
>
> BRT LOG:  database system was interrupted while in recovery at 2009-04-23
> 10:50:42 BRT
> BRT HINT:  This probably means that some data is corrupted and you will have
> to use the last backup for recovery.
> BRT LOG:  checkpoint record is at 8D7/4B49F558
>  BRT LOG:  redo record is at 8D7/4B3F8808; undo record is at 0/0; shutdown
> FALSE
>  BRT LOG:  next transaction ID: 4/330074329; next OID: 491520
>  BRT LOG:  next MultiXactId: 26619703; next MultiXactOffset: 79878305
>  BRT LOG:  database system was not properly shut down; automatic recovery in
> progress
>  BRT LOG:  redo starts at 8D7/4B3F8808
> alguma sugestao?
>


Seguir a recomendação do PostgreSQL "you will have to use the last
backup for recovery" está fora de cogitação?

Osvaldo
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a