From: | Jose Quiroz <soporteinterno(at)healtechnology(dot)com(dot)pe> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | I can't restart postgres |
Date: | 2008-02-01 23:39:25 |
Message-ID: | B52EB382-DFE7-49D7-B357-A0D2DA510557@healtechnology.com.pe |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I need help to start the postgres. The server was shutdown improperly
and after that we can't restart the postgres.
Here is the log that show in the screen when I try to start the
postgres.
The log is in spanish, but at the end I write the log in english.
Starting PostgreSQL 8.1 database server: mainThe PostgreSQL server
failed to start. Please check the log output:
2008-02-01 17:53:22 PET LOG: no se pudo cargar el archivo del
certificado raíz «root.crt»: No SSL error reported
2008-02-01 17:53:22 PET DETALLE: Los certificados de clientes no se
verificarán.
2008-02-01 17:53:22 PET LOG: el sistema de bases de datos fue
interrumpido durante la recuperación en 2008-02-01 17:31:23 PET
2008-02-01 17:53:22 PET HINT: Esto probablemente significa que
algunos datos están corruptos y tendrá que usar el respaldo más
reciente para la recuperación.
2008-02-01 17:53:22 PET LOG: el registro de checkpoint está en
99/3F575168
2008-02-01 17:53:22 PET LOG: registro de redo en 99/3F50808C;
registro de undo en 0/0; apagado FALSE
2008-02-01 17:53:22 PET LOG: siguiente ID de transacción:
1557744310; siguiente OID: 26588
2008-02-01 17:53:22 PET LOG: siguiente MultiXactId: 431502448;
siguiente MultiXactOffset: 3204059784
2008-02-01 17:53:22 PET LOG: el sistema de bases de datos no fue
apagado apropiadamente; se está efectuando la recuperación automática
2008-02-01 17:53:22 PET LOG: redo comienza en 99/3F50808C
2008-02-01 17:53:22 PET LOG: el paquete de inicio está incompleto
2008-02-01 17:53:23 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:23 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:24 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:24 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:25 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:25 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:26 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:26 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:27 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:27 PET FATAL: el sistema de base de datos está
iniciándose
2008-02-01 17:53:33 PET PANIC: no se pudo leer el bloque 3788 de la
relación 1663/17977/18281: Conseguido
2008-02-01 17:53:33 PET LOG: proceso de inicio (PID 18921) fue
terminado por una señal 6
2008-02-01 17:53:33 PET LOG: abortando el inicio debido a una falla
en el procesamiento de inicio
failed!
Here is the log in English :
2008-02-01 17:53:22 PET LOG: the «root.crt» couldn't load: No SSL
error reported
2008-02-01 17:53:22 PET DETALLE: The clients certificates won't be
verified
2008-02-01 17:53:22 PET LOG: the data base system was interrupted
during the recover in 2008-02-01 17:31:23 PET el sistema de bases
de datos fue interrumpido durante la recuperación en 2008-02-01
17:31:23 PET
2008-02-01 17:53:22 PET HINT: This probably means that some data are
corrupt and you have to use the recently backup to restore the system.
2008-02-01 17:53:22 PET LOG: the checkpoint register is in
99/3F575168
2008-02-01 17:53:22 PET LOG: redo register is in 99/3F50808C; undo
register in 0/0; FALSE off
2008-02-01 17:53:22 PET LOG: next ID of transaction: 1557744310;
next OID:26588
2008-02-01 17:53:22 PET LOG: next MultiXactld: 431502448; next
MultiXactOffset:3204059784
2008-02-01 17:53:22 PET LOG: The data base system was shutdown
improperly: The auto restore is execute.
2008-02-01 17:53:22 PET LOG: redo starts in 99/3F50808C
2008-02-01 17:53:22 PET LOG: start package is incomplete
2008-02-01 17:53:23 PET FATAL: starting data base system
2008-02-01 17:53:23 PET FATAL: starting data base system
2008-02-01 17:53:24 PET FATAL: starting data base system
2008-02-01 17:53:24 PET FATAL: starting data base system
2008-02-01 17:53:25 PET FATAL: starting data base system
2008-02-01 17:53:25 PET FATAL: starting data base system
2008-02-01 17:53:26 PET FATAL: starting data base system
2008-02-01 17:53:26 PET FATAL: starting data base system
2008-02-01 17:53:27 PET FATAL: starting data base system
2008-02-01 17:53:27 PET FATAL: starting data base system
2008-02-01 17:53:33 PET PANIC: Block 3788 of 1663/17977/18281
relation can't read :
2008-02-01 17:53:33 PET LOG: Start process (PID 18921) was stop by a
6 signal
2008-02-01 17:53:33 PET LOG: Aborting the start because a fail in
the start process
failed!
I use the pgfsck but doesn't work, How I can restart the systema again?
Jose Quiroz
soporteinterno(at)healtechnology(dot)com(dot)pe
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-02-02 00:21:43 | Re: I can't restart postgres |
Previous Message | Santiago Zarate | 2008-02-01 23:36:23 | Re: [GENERAL] PostgreSQL Certification |