[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.