Re: Power Electrical Down!!!!! - Mailing list pgsql-general

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/