[Pgsql-ayuda] error

Felipe Fernandez danielfm@teleline.es
Wed, 10 Sep 2003 23:21:00 +0100


El postmaster no me arranca y en el log obtengo lo siguiente.

2003-09-10 23:21:44 [761]    DEBUG:  database system was interrupted 
being in recovery at 2003-09-10 23:16:28 WEST
        This probably means that some data blocks are corrupted
        and you will have to use the last backup for recovery.
2003-09-10 23:21:44 [761]    DEBUG:  checkpoint record is at 0/4C4BE388
2003-09-10 23:21:44 [761]    DEBUG:  redo record is at 0/4C4BE388; undo 
record is at 0/0; shutdown TRUE
2003-09-10 23:21:44 [761]    DEBUG:  next transaction id: 1837413650; 
next oid: 1081238
2003-09-10 23:21:44 [761]    DEBUG:  database system was not properly 
shut down; automatic recovery in progress
2003-09-10 23:21:44 [761]    DEBUG:  redo starts at 0/4C4BE3C8
2003-09-10 23:21:44 [761]    FATAL 2:  read of clog file 1752, offset 
73728 failed: Success
2003-09-10 23:21:44 [758]    DEBUG:  startup process (pid 761) exited 
with exit code 2
2003-09-10 23:21:44 [758]    DEBUG:  aborting startup due to startup 
process failure


No hay ninguna manera de recuperar las bases de datos. Esto ha salido 
justo antes de hacer las copias de seguridad y solo tengo las de ayer noche.