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[31m*[39;49m 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.
