Re: Caida de base de datos PostgreSQL

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 <fasterzip(at)yahoo(dot)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 <wilson1901(at)gmail(dot)com>
> *Para:* Ayuda <pgsql-es-ayuda(at)postgresql(dot)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
>
>
>