Re: invalid primary checkpoint record - Mailing list pgsql-general

From Tom Lane
Subject Re: invalid primary checkpoint record
Date
Msg-id 15150.1151505943@sss.pgh.pa.us
Whole thread Raw
In response to invalid primary checkpoint record  (zhicheng wang <wang_zc@yahoo.co.uk>)
List pgsql-general
zhicheng wang <wang_zc@yahoo.co.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

pgsql-general by date:

Previous
From: "A.M."
Date:
Subject: Re: Null and Void() - Or,
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Null and Void() - Or,