Re: unable to locate a valid checkpoint - Mailing list pgsql-admin

From Tom Lane
Subject Re: unable to locate a valid checkpoint
Date
Msg-id 2520.1016820941@sss.pgh.pa.us
Whole thread Raw
In response to unable to locate a valid checkpoint  (Auri Mason <amason@syntrex.com>)
Responses Re: unable to locate a valid checkpoint  (Auri Mason <amason@syntrex.com>)
List pgsql-admin
Auri Mason <amason@syntrex.com> writes:
> I'm quite new for this list, but I've already a big problem.
> After a shutdown, the postmaster doesn't restart due to a checkpoint
> error.

"Shutdown"?  Exactly what happened there?  It certainly doesn't look
like you had a clean shutdown.

At this point I think your only hope is contrib/pg_resetxlog, but that's
a very blunt instrument.  It'd be nice to understand what went wrong.

            regards, tom lane

pgsql-admin by date:

Previous
From: Auri Mason
Date:
Subject: unable to locate a valid checkpoint
Next
From: "David"
Date:
Subject: access is denied completely from postgresql!!