[Pgsql-ayuda] Postmaster no levanta
Carmen Gloria Sepulveda Dedes
csepulveda@atichile.com
Mon, 20 Oct 2003 10:57:21 -0300
Hola a todos.
Tuve el siguiente problema.
Estaba intentando crear una tabla y cometi un error de tipeo:
mdbs=# create table talseria ();
PANIC: XLogWrite: write request 0/94A000 is past end of log 0/94A000
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#
Despues de esto, perdi la conexion a la base de datos. Sali de psql y
al intentar entrar de nuevo, me dice que no esta corriendo el proceso
postmaster. Al intentar levantarlo, aparece lo siguiente:
huapi@rmadmin:~> postmaster -B 32 -N 16 -i &
[1] 743
huapi@rmadmin:~> LOG: database system shutdown was interrupted at
2003-10-20 10:51:19 CLST
LOG: checkpoint record is at 0/949FC0
LOG: redo record is at 0/949FC0; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 646; next oid: 17009
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: ReadRecord: invalid magic number 0000 in log file 0, segment 0,
offset 9740288
LOG: redo is not required
PANIC: XLogWrite: write request 0/94A000 is past end of log 0/94A000
LOG: startup process (pid 746) was terminated by signal 6
LOG: aborting startup due to startup process failure
y el proceso no sube. Alguien me puede explicar por favor, como
solucionar este
problema??
Saludos y gracias.