Re: [pgbr-geral] Erro ao iniciar o postgresql
JacksonWeber escreveu: 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. (...) 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. (...) Alguém tem alguma idéia. Eu não, mas o elefante teve e informou a você ali no HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. Use o último backup. -- Dickson S. Guedes Administrador de Banco de Dados Confesol - Projeto Colmeia Florianopolis, SC, Brasil (48) 3322-1185, ramal: 26 ___ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
Re: [pgbr-geral] Erro ao iniciar o postgresql
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/0001000300DA (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/0001000300DA (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
[pgbr-geral] Erro ao iniciar o postgresql
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/0001000300DA (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/0001000300DA (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
