Recovery Data Cant Be!!! - Mailing list pgsql-general

From Edwin Quijada
Subject Recovery Data Cant Be!!!
Date
Msg-id BAY1-F98ZgR1zRL25AE0001302f@hotmail.com
Whole thread Raw
Responses Re: Recovery Data Cant Be!!!
Re: Recovery Data Cant Be!!!
List pgsql-general
Hi!!
There is an app to recover data for postgres after inapropiate server
shutdown or power electrical down?
I have a great problem. My system go down inapropiate and now my server
doesnt up.
What 's up with my data?
I lost my data?
I dont believe that a robust database like postgres is so weak for power
down and understand that can go down electrical power but fail 2 ups.

If somebody has any idea to help me this is the log file

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 Beethoven to the Rolling Stones, your favorite music is always playing
on MSN Radio Plus. No ads, no talk. Trial month FREE!
http://join.msn.com/?page=offers/premiumradio


pgsql-general by date:

Previous
From: "Edwin Quijada"
Date:
Subject: Re: Service doesnt UP!!!!
Next
From: Jeff
Date:
Subject: Re: Recovery Data Cant Be!!!