[Pgsql-ayuda] Postmaster no levanta

From: Carmen Gloria Sepulveda Dedes <csepulveda(at)atichile(dot)com>
To: Pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: [Pgsql-ayuda] Postmaster no levanta
Date: 2003-10-20 13:57:21
Message-ID: 3F93E9C1.82BB8E36@atichile.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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(at)rmadmin:~> postmaster -B 32 -N 16 -i &
[1] 743
huapi(at)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.

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Roberto Andrade Fonseca 2003-10-20 16:20:55 [Pgsql-ayuda] Nombres de objetos de bases de datos
Previous Message Martin Marques 2003-10-19 23:05:02 Re: [Pgsql-ayuda] Cambio de indices