zhicheng wang <wang_zc(at)yahoo(dot)co(dot)uk> writes:
> the computer was shutdown properly. then the user
> restarted the computer, in the middle of rebooting, he
> switched off the power button on the wall. after that
> we cannot start the database server any more. the
> following is the log. please help.
You can probably get out of this with pg_resetxlog, but after that you
need to take a hard look at that machine's disk drive setup. It's
evidently lying about write-complete (ie, not doing writes in the
commanded order), else you could not have got into this state.
regards, tom lane