Hola Alejandro lei el articulo que me indicaste ejecute el proceso pg_resetxlog y este fue el resultado:
server:bin postgres$ /Library/PostgreSQL/8.4/bin/pg_resetxlog -f /Volumes/RAIDMETERS/Library/PostgreSQL/8.4/data Transaction log reset server:bin postgres$ /Library/PostgreSQL/8.4/bin/pg_ctl -D /Volumes/RAIDMETERS/Library/PostgreSQL/8.4/data -l /Volumes/RAIDMETERS/Library/PostgreSQL/8.4/data/postgresql.log start server:bin postgres$ tail -f /Volumes/RAIDMETERS/Library/PostgreSQL/8.4/data/postgresql.log 2013-02-26 18:40:18 PET 28563 LOG: startup process (PID 28564) exited with exit code 1 2013-02-26 18:40:18 PET 28563 LOG: aborting startup due to startup process failure 2013-02-26 18:45:48 PET 28771 LOG: database system was interrupted; last known up at 2013-02-26 18:45:39 PET 2013-02-26 18:45:48 PET 28771 LOG: database system was not properly shut down; automatic recovery in progress 2013-02-26 18:45:48 PET 28771 LOG: record with zero length at 33F/8C0000EC 2013-02-26 18:45:48 PET 28771 LOG: redo is not required 2013-02-26 18:45:48 PET 28771 FATAL: could not access status of transaction 61949327 2013-02-26 18:45:48 PET 28771 DETAIL: Could not read from file "pg_multixact/members/03B1" at offset 65536: Unknown error: 0. 2013-02-26 18:45:48 PET 28770 LOG: startup process (PID 28771) exited with exit code 1 2013-02-26 18:45:48 PET 28770 LOG: aborting startup due to startup process failure Como verás o no funciona el pg_resetxlog o no le di los parametros indicados, alguna idea ? Atte. Wilson Del Rosario Montero Analista Programador 2013/2/26 Alejandro Carrillo <faster...@yahoo.es> > Veo que le diste un mamotrazo al servidor postgresql. > Te recomiendo leas esto: > > http://stackoverflow.com/questions/12897429/what-does-pg-resetxlog-do-and-how-does-it-work > Y preparate para borrar todas las transacciones que no hayan sido > aceptadas (commit) antes del fallo, con este comando(pg-resetxlog). > > ------------------------------ > *De:* Wilson del rosario <wilson1...@gmail.com> > *Para:* Ayuda <pgsql-es-ayuda@postgresql.org> > *Enviado:* Martes 26 de febrero de 2013 14:27 > *Asunto:* [pgsql-es-ayuda] Caida de base de datos PostgreSQL > > Hola a todos estoy trabajando con postgres 8.4 sobre el sistema operativo > MAC OS X el problema es que no levanta la base de datos y en el log aparece > el siguiente mensaje: > > server:~ postgres$ /Library/PostgreSQL/8.4/bin/pg_ctl -D > /Volumes/RAIDMETERS/Library/PostgreSQL/8.4/data start > server starting > royaleserver:~ postgres$ 2013-02-24 12:46:51 PET 48760 LOG: database > system was interrupted while in recovery at 2013-02-24 12:46:49 PET > 2013-02-24 12:46:51 PET 48760 HINT: This probably means that some data > is corrupted and you will have to use the last backup for recovery. > 2013-02-24 12:46:51 PET 48760 LOG: database system was not properly > shut down; automatic recovery in progress > 2013-02-24 12:46:51 PET 48760 LOG: redo starts at 33F/785CFB4 > 2013-02-24 12:46:51 PET 48760 FATAL: could not access status of > transaction 18245564 > 2013-02-24 12:46:51 PET 48760 DETAIL: Could not read from file > "pg_multixact/members/03B1" at offset 65536: Unknown error: 0. > 2013-02-24 12:46:51 PET 48760 CONTEXT: xlog redo create multixact > 18245564 offset 61949327: 1259116611 1259116612 > 2013-02-24 12:46:51 PET 48757 LOG: startup process (PID 48760) exited > with exit code 1 > 2013-02-24 12:46:51 PET 48757 LOG: aborting startup due to startup > process failure > > Alguien me podría explicar cual es el problema y como puedo solucionarlo, > muchas gracias. > > Si necesitan mas datos por favor no duden en consultar. > > Atte. > Wilson Del Rosario Montero > Analista Programador > > >
