Re: after using pg_resetxlog, db lost

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: after using pg_resetxlog, db lost
Дата
Msg-id 40BCA74C.70407@archonet.com
обсуждение исходный текст
Ответ на Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Ответы Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Список pgsql-general
zhicheng wang wrote:
> Hi Richard Huxton
>
> sorry to have bothered you with trivial things.
>
> the reindex give these error:
>
> backend> REINDEX DATABASE miamevice;
> ERROR:  XLogFlush: request 0/BB4C3560 is not satisfied
> --- flushed only to 0/20001D8
> WARNING:  write error may be permanent: cannot write
> block 29 for 4205811/1249
> backend> \q;
> ERROR:  parser: parse error at or near "\" at
> character 1
> backend> q\;
> ERROR:  parser: parse error at or near "q" at
> character 1
> backend> LOG:  shutting down
> PANIC:  XLogFlush: request 0/BB4C3560 is not satisfied
> --- flushed only to 0/20001D8
> Aborted
>
>
> does this mean that we cannot recover our data?

Well the problems with "\q" are because you need to press CTRL+D to end
the session. The inability to write is something I've not seen before,
so I've cc'd Tom Lane on this.

It doesn't look good though.

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-general по дате отправления:

Предыдущее
От: zhicheng wang
Дата:
Сообщение: Re: after using pg_resetxlog, db lost
Следующее
От: Josué Maldonado
Дата:
Сообщение: Re: Insert speed question