2008/11/26 JacksonWeber <[EMAIL PROTECTED]> > > ao iniciar o postgresql apresenta este erro no console. > > [EMAIL PROTECTED] pg_xlog]$ LOG: database system was interrupted while > in recovery at 2008-11-26 15:30:42 BRST > HINT: This probably means that some data is corrupted and you will have to > use the last backup for recovery. > LOG: could not open file "/dados/data1/pg_xlog/0000000100000003000000DA" > (log file 3, segment 218): Arquivo ou diretório não encontrado > LOG: invalid primary checkpoint record > LOG: could not open file "/dados/data1/pg_xlog/0000000100000003000000DA" > (log file 3, segment 218): Arquivo ou diretório não encontrado > LOG: invalid secondary checkpoint record > PANIC: could not locate a valid checkpoint record > LOG: startup process (PID 2996) was terminated by signal 6 > LOG: aborting startup due to startup process failure > > e após eu criar o arquivo que ele reclama que falta, apresenta o seguinte > erro: > > [EMAIL PROTECTED] pg_xlog]$ LOG: database system was interrupted while > in recovery at 2008-11-26 15:30:42 BRST > HINT: This probably means that some data is corrupted and you will have to > use the last backup for recovery. > LOG: could not read from log file 3, segment 218 at offset 14352384: > Arquivo ou diretório não encontrado > LOG: invalid primary checkpoint record > LOG: could not read from log file 3, segment 218 at offset 8642560: > Arquivo > ou diretório não encontrado > LOG: invalid secondary checkpoint record > PANIC: could not locate a valid checkpoint record > LOG: startup process (PID 3023) was terminated by signal 6 > LOG: aborting startup due to startup process failure > > Alguém tem alguma idéia. > -- > View this message in context: > http://www.nabble.com/Erro-ao-iniciar-o-postgresql-tp20709884p20709884.html > Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. > > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >
Jackson, Tente usar o comando pg_resetxlog. -- °v° Ricardo Gonçalves /(_)\ Dpto de Sistemas ^ ^ Multcont Informática Ltda
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral