Power Electrical Down!!!!!

I am trying running up using
pg_ctl -D /data/dir -l logfile

This is the last 100 lines from log

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 C
ET
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 C
ET
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 C
ET
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: MaRcElO PeReIrA <gandalf_mp@yahoo.com.br>
To: Edwin Quijada <listas_quijada@hotmail.com>
Subject: Re: [GENERAL] Power Electrical Down!!!!!
Date: Fri, 7 Nov 2003 16:03:26 -0300 (ART)

Hi there,

First of all, you have not lost your data!! Unless in
case of hardware corruption!

Well, run the postgres with the -l flag and take a
look at the error:

$ pg_ctl -D /data/dir -l logfile

Let us see what is going on the logfile!!

Regards,

MaRcElO PeReirA
PHP/SQL/PostgreSQL

--- Edwin Quijada <listas_quijada@hotmail.com>
escreveu: > Hi!!!

I had a break electrical service and my system go
down. Now when I try to up
the postgres service I get this error:

psql: could not connect to server: No such file or
directory
Is the server running locally and accepting
connections on Unix domain socket
"/tmp/.s.PGSQL.5432"?
createdb: database creation failed

I went to directory data and delete postmaster.pid
and postmaster.opts but
nothing happens.
I have the same error.
PLease I need urgent help!!!

I lost my data??
What can I do to back service up with my data??

*-------------------------------------------------------*

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

*-------------------------------------------------------*

_________________________________________________________________

Charla con tus amigos en l�nea mediante MSN
Messenger:
http://messenger.yupimsn.com/

---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the
unregister command
(send "unregister YourEmailAddressHere" to

majordomo@postgresql.org)

Yahoo! Mail - 6MB, anti-spam e antiv�rus gratuito. Crie sua conta agora:
http://mail.yahoo.com.br

_________________________________________________________________
�Est�s buscando un auto nuevo? http://www.yupimsn.com/autos/

On Fri, 7 Nov 2003, Edwin Quijada wrote:

I am trying running up using
pg_ctl -D /data/dir -l logfile

This is the last 100 lines from log

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

See http://archives.postgresql.org/pgsql-admin/2003-09/msg00423.php