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

RE: PANIC: No levanta Postgres

From: mmiranda(at)americatel(dot)com(dot)sv
To: mario(at)cfrd(dot)cl, pgsql-es-ayuda(at)postgresql(dot)org
Subject: RE: PANIC: No levanta Postgres
Date: 2005-04-29 22:28:02
Message-ID: 76E0DAA32C39D711B6EC0002B364A6FA0445C37E@amsal01exc01.americatel.com.sv (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
pgsql-es-ayuda-owner(at)postgresql(dot)org wrote:
> El vie, 29-04-2005 a las 14:19 -0600, mmiranda(at)americatel(dot)com(dot)sv
> escribió:
>> Estimados, algo terrible ha ocurrido, un tecnico que estaba
>> trabajando en un servidor cercano al de base de datos se paso
>> llevando el cable de poder del servidor,
>   Uff, el que esta frito ademas es el tecnico parece ; )
> 
>>  al volver aa conectarlo todo parecia que estaba normal pero no
>> levanto el servicio postgres, este es el log de arranque:
> 
>> LOG:  database system was interrupted being in recovery at
>>         2005-04-29 14:10:43 CST This probably means that some data
>>         blocks are corrupted and you will have to use the last
>> backup for recovery. 
>> LOG:  checkpoint record is at F1/A0A4E05C
>> LOG:  redo record is at F1/A0A4E05C; undo record is at 0/0; shutdown
>> TRUE LOG:  next transaction id: 98967076; next oid: 151578857
>> LOG:  database system was not properly shut down; automatic recovery
>> in progress LOG:  redo starts at F1/A0A4E09C
>> PANIC:  Invalid page header in block 68122 of 17006
>> LOG:  startup process (pid 1959) was terminated by signal 6
>> LOG:  aborting startup due to startup process failure
>> 
>> Alguna sugerencia?, aparte de  restaurar del backup como dice el log?
> 
>    Que sistema de archivos estabas usando?  Pregunto para descartar,
> si usas alguno con Journaling puedes tratar reparando el FileSystem
> con las herramientas correspondientes. Por ejemplo si usas XFS debes
> tener el paquete xfs_progs.
> 
>> Estoy frito?


Ya pase el fsck y nada, estoy usando ext3,

pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2005-04-29 22:32:51
Subject: Re: PANIC: No levanta Postgres
Previous:From: Mario GonzalezDate: 2005-04-29 21:26:52
Subject: Re: PANIC: No levanta Postgres

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