Re: [Pgsql-ayuda] HELP!!!!!!!!!--Se me cayo el servicio

From: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>
To: pmunoz(at)cmet(dot)net
Cc: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: Re: [Pgsql-ayuda] HELP!!!!!!!!!--Se me cayo el servicio
Date: 2003-11-07 17:57:20
Message-ID: BAY1-F162tfQyupGKy300017af3@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Mira aca esta mi log: no se si servira de mucho pero al menos tal vez puedas
darme una idea.
Postgres es tan simple por la caida de voltage, es decir, no existe una
herrmaienta que pueda recuperar la data o subir de nuevo el servicio.
En la carpeta tmp no hay nada :(
Debo resignarme a perder mi data??
:(

The server must be started under an unprivileged user id to prevent
a possible system security compromise. See the documentation for
more information on how to properly start the server.

LOG: database system was interrupted at 2003-11-07 10:54:32 CET
LOG: checkpoint record is at 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1327) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:33:19 CET
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 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1354) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:35:34 CET
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 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1090) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:40:47 CET
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 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1196) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:46:13 CET
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 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1531) was terminated by signal 6
LOG: aborting startup due to startup process failure

*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

>From: Patricio Muoz <pmunoz(at)cmet(dot)net>
>To: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>
>CC: <pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx>
>Subject: Re: [Pgsql-ayuda] HELP!!!!!!!!!--Se me cayo el servicio
>Date: Fri, 7 Nov 2003 14:38:11 -0300
>
>
> > Fui a la carpeta /tmp pero no aparece nada como lo qe dice el mensaje.
>Trate
> > de subir de nuevo el servicio y nada. Cuando voy a la carpeta data no
> > aparece el archivo postgres.pid??
> > Alguien tiene alguna sugrerencia?? :(
>
>Buscate todos los archivos en la carpeta /tmp ?, inclusive los ocultos ?
>
>Saludos
>

_________________________________________________________________
Compare high-speed Internet plans, starting at $26.95.
https://broadband.msn.com (Prices may vary by service area.)

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Edwin Quijada 2003-11-07 17:59:16 [Pgsql-ayuda] Re: Ayuda!! No me sube el servico de la base de datos
Previous Message Alvaro Herrera 2003-11-07 17:54:47 [Pgsql-ayuda] Re: Ayuda!! No me sube el servico de la base de datos