[Pgsql-ayuda] Re: Ayuda!! No me sube el servico de la base de datos

[Edwin Quijada]

Mira lo que pasa es que el no esta creando el postmaster.pid:
Aca esta el log del servidor despues del momento de la caida:

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

No existe alguna herramienta para tratar de recuperar esa data en 
postgres???
Pense en craer initdb de nuevo sacando un backup primero de mi carpeta data 
y luego sustituirlo por esta . Que opinas??


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





>From: Alvaro Herrera <alvherre@dcc.uchile.cl>
>To: Edwin Quijada <listas_quijada@hotmail.com>
>CC: pgsql-ayuda@tlali.iztacala.unam.mx
>Subject: Re: Ayuda!! No me sube el servico de la base de datos
>Date: Fri, 7 Nov 2003 14:25:59 -0300
>
>On Fri, Nov 07, 2003 at 04:08:50PM +0000, Edwin Quijada wrote:
>
> > Hola! ALvaro y disculpa el enviarte el correo directamente pero la lista
> > ultimamente esta imposible de enviar un correo.
> > Tuve una caida de electricidad y ahora el servicio no quiere subir. Fui 
>a
> > la carpeta data y borre postmaster.opts y .pid pero nada reinicie la
> > maquina sin esto y nada . El error que me da es el famoso de que 
>postgres
> > no esta oyendo en el puerto 5432 ./tmp/s.5432 y esas cosas que ya seguro
> > sabes.\
>
>Bueno, si dice que no está oyendo es porque eso es lo que pasa ...
>revisa en los registros del servidor, quizás hay alguna pista.  Así a
>ciegas no sé qué decirte ...
>
>--
>Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
>"Tiene valor aquel que admite que es un cobarde" (Fernandel)

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