Error al start

From: Kalelx <kalelx(at)openkb(dot)com(dot)ar>
To: PostgresLista <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Error al start
Date: 2008-08-12 20:55:21
Message-ID: aa5530c60808121355q1b602bd7m6aef3d29ad5e8008@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola gente:

En un server con debian etch y postgres 8.1 , me estuvo dando en el log
problemas de que no encuentar el pg_clog, al cabo de un tiempo los programas
me daban error de conexion en forma aleatoria y despues continuamente, al
intentar dar un stop, y luego un start me salto el siguiente error y el
postgres se murio:

server:~# /etc/init.d/postgresql-8.1 start
Starting PostgreSQL 8.1 database server: main* The PostgreSQL
server failed to start. Please check the log output:
2008-08-12 17:41:42 ART LOG: could not load root certificate file
"root.crt": No SSL error reported
2008-08-12 17:41:42 ART DETAIL: Will not verify client certificates.
2008-08-12 17:41:42 ART LOG: database system was interrupted while in
recovery at 2008-08-12 17:38:04 ART
2008-08-12 17:41:42 ART HINT: This probably means that some data is
corrupted and you will have to use the last backup for recovery.
2008-08-12 17:41:42 ART LOG: checkpoint record is at 2/8ED2BD10
2008-08-12 17:41:42 ART LOG: redo record is at 2/8ED2BD10; undo record is
at 0/0; shutdown TRUE
2008-08-12 17:41:42 ART LOG: next transaction ID: 2168823; next OID:
3942517
2008-08-12 17:41:42 ART LOG: next MultiXactId: 1; next MultiXactOffset: 0
2008-08-12 17:41:42 ART LOG: database system was not properly shut down;
automatic recovery in progress
2008-08-12 17:41:42 ART LOG: redo starts at 2/8ED2BD60
2008-08-12 17:41:42 ART PANIC: btree_delete_page_redo: lost right sibling
2008-08-12 17:41:42 ART LOG: startup process (PID 2765) was terminated by
signal 6
2008-08-12 17:41:42 ART LOG: aborting startup due to startup process
failure
failed!

me podrian dar una mano para poder levantarlo?

gracias.

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Cristián Osorio 2008-08-12 20:57:07 Fwd: Ayuda Respaldo incremental
Previous Message Rodrigo Fuentealba 2008-08-12 20:53:34 Re: [pgsql.cl] Re: OT consulta postgres.cl