Serios problemas para arrancar Postgres

From: Vida Luz <vlal(at)ns(dot)ideay(dot)net(dot)ni>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Serios problemas para arrancar Postgres
Date: 2007-05-14 20:10:56
Message-ID: Pine.LNX.4.64.0705141408530.2981@ns.ideay.net.ni
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Buenas Tardes

Encontre un serio problema con Postgres, la particios /var se lleno y
ahora el postgres no arranca, en el directorio pg_xlog no hay archivos, y
por ahi viene el problemas, esto me arroja el log:

2007-05-14 14:10:21 CST WARNING: autovacuum not started because of
misconfiguration
2007-05-14 14:10:21 CST HINT: Enable options "stats_start_collector"
and "stats_row_level".
2007-05-14 14:10:21 CST LOG: database system was interrupted at
2007-05-12 09:02:23 CST
2007-05-14 14:10:21 CST LOG: could not open file
"pg_xlog/000000010000000E00000084" (log file 14, segment 132): No such
file or directory
2007-05-14 14:10:21 CST LOG: invalid primary checkpoint record
2007-05-14 14:10:21 CST LOG: could not open file
"pg_xlog/000000010000000E0000007F" (log file 14, segment 127): No such
file or directory
2007-05-14 14:10:21 CST LOG: invalid secondary checkpoint record
2007-05-14 14:10:21 CST PANIC: could not locate a valid checkpoint
record
2007-05-14 14:10:21 CST LOG: startup process (PID 5220) was terminated
by signal 6
2007-05-14 14:10:21 CST LOG: aborting startup due to startup process
failure
2007-05-14 14:10:21 CST LOG: logger shutting down

Como puedo solucionar este problema ? resulta que el ultimo backup de la
BD no lo tengo.

Gracias.

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message usuario anonimo 2007-05-14 21:41:44 Re: Ayuda con consulta
Previous Message Patricio Cifuentes Ithal 2007-05-14 19:37:52 RE: Expresar lo mas claro posible