Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-es-ayuda by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group