Re: after using pg_resetxlog, db lost

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