Caida de base de datos PostgreSQL

From: Wilson del rosario <wilson1901(at)gmail(dot)com>
To: Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Caida de base de datos PostgreSQL
Date: 2013-02-26 19:27:31
Message-ID: CAMx0+d3NqVc2jxFSs=i8bC5pqhLyk_wXLwm0nVm4_5hoJujPpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alejandro Carrillo 2013-02-26 20:07:10 Re: Caida de base de datos PostgreSQL
Previous Message Anthony 2013-02-26 19:10:28 Re: Calcular cantidad semanas