Обсуждение: I can't restart postgres
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@healtechnology.com.pe
Jose Quiroz <soporteinterno@healtechnology.com.pe> writes: > 2008-02-01 17:53:33 PET PANIC: no se pudo leer el bloque 3788 de la > relaci�n 1663/17977/18281: Conseguido Hmm, what PG version is that? This looks a bit like the results of some bugs that were fixed awhile ago. > I use the pgfsck but doesn't work, How I can restart the systema again? Well, if you don't have a recent backup to go back to, you can try pg_resetxlog, but it's anyone's guess how consistent the database will be afterwards. A dump/initdb/restore sequence would be a good idea. And if you aren't on the latest release in whatever branch you are using, now would be a good time to update. regards, tom lane
The version of postgres is 8.1 And i don't have any backup of the system, I think that could be a problem to restore the system. thanks for answer. regards, jose On 01/02/2008, at 07:21 PM, Tom Lane wrote: > Jose Quiroz <soporteinterno@healtechnology.com.pe> writes: >> 2008-02-01 17:53:33 PET PANIC: no se pudo leer el bloque 3788 de la >> relación 1663/17977/18281: Conseguido > > Hmm, what PG version is that? This looks a bit like the results of > some > bugs that were fixed awhile ago. > >> I use the pgfsck but doesn't work, How I can restart the systema >> again? > > Well, if you don't have a recent backup to go back to, you can try > pg_resetxlog, but it's anyone's guess how consistent the database > will be afterwards. A dump/initdb/restore sequence would be a good > idea. And if you aren't on the latest release in whatever branch > you are using, now would be a good time to update. > > regards, tom lane > Jose Quiroz soporteinterno@healtechnology.com.pe
On Feb 1, 2008 11:49 PM, Jose Quiroz <soporteinterno@healtechnology.com.pe> wrote: > The version of postgres is 8.1 > And i don't have any backup of the system, I think that could be a > problem to restore the system. 8.1.what?
Thanks for the help. I use the pg_resetxlog and the database start again. Now I have other problem. I try to view a table using the command select and I have an error and I can't view the table. I wrote the following line in the terminal: htpoweron=# select * from example_table; (where example_table is one table of my database) and I have the following message in the terminal: ERROR: could not access status of transaction 1557774552 DETAIL: could not read from file «pg_clog/05CD» at offset 155648: What I can do to acces that table? Best regards On 01/02/2008, at 07:21 PM, Tom Lane wrote: > Jose Quiroz <soporteinterno@healtechnology.com.pe> writes: >> 2008-02-01 17:53:33 PET PANIC: no se pudo leer el bloque 3788 de la >> relación 1663/17977/18281: Conseguido > > Hmm, what PG version is that? This looks a bit like the results of > some > bugs that were fixed awhile ago. > >> I use the pgfsck but doesn't work, How I can restart the systema >> again? > > Well, if you don't have a recent backup to go back to, you can try > pg_resetxlog, but it's anyone's guess how consistent the database > will be afterwards. A dump/initdb/restore sequence would be a good > idea. And if you aren't on the latest release in whatever branch > you are using, now would be a good time to update. > > regards, tom lane > Jose Quiroz soporteinterno@healtechnology.com.pe