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 по дате отправления:

Предыдущее
От: Jose Quiroz
Дата:
Сообщение: I can't restart postgres
Следующее
От: "Vyacheslav Kalinin"
Дата:
Сообщение: Re: problem with ORDER BY