Обсуждение: lost /pg_xlog

Hi there,

i have a situation on my sandbox:
pg_xlog directory of cluster was gone at stopped postgres. it was on another disk
which has broken. in this situation postgres falling to .core at startup with messages:
---
LOG:  could not open file "pg_xlog/000000030000000100000058" (log file 1, segment 88): No such file or directory
LOG:  invalid primary checkpoint record
---
before that happened postgres was shutdown normally.

i so understand that database is consistent, no? why we couldn't start?

---
Alexander Vysokovskih

Alexander Vysokovskih <av@ural.org> writes:
> ---
> LOG:  could not open file "pg_xlog/000000030000000100000058" (log file 1, segment 88): No such file or directory
> LOG:  invalid primary checkpoint record
> ---
> before that happened postgres was shutdown normally.

If so, pg_resetxlog will get you out of this.

            regards, tom lane