[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.