Re: I can't restart postgres
| От | Tom Lane |
|---|---|
| Тема | Re: I can't restart postgres |
| Дата | |
| Msg-id | 18318.1201911703@sss.pgh.pa.us обсуждение |
| Ответ на | I can't restart postgres (Jose Quiroz <soporteinterno@healtechnology.com.pe>) |
| Ответы |
Re: I can't restart postgres
Re: I can't restart postgres |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: