Обсуждение: unable to locate a valid checkpoint

Hi to all,

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.
The data of the DB is ... ehm important... so, how can I recover my
installation?

message:
##########################################

FindExec: found "/usr/bin/postmaster" using argv[0]
2002-03-22 13:42:46 [6002]   DEBUG:  database system was shut down at
2002-03-22 11:46:11 CET
2002-03-22 13:42:46 [6002]   DEBUG:  ReadRecord: invalid resource manager
id 157 at (0, 561372168)
2002-03-22 13:42:46 [6002]   DEBUG:  Invalid primary checkPoint record
2002-03-22 13:42:46 [6002]   DEBUG:  Invalid RMID in secondary checkPoint
record
2002-03-22 13:42:46 [6002]   FATAL 2:  Unable to locate a valid CheckPoint
record
2002-03-22 13:42:46 [6002]   DEBUG:  proc_exit(2)
2002-03-22 13:42:46 [6002]   DEBUG:  shmem_exit(2)
2002-03-22 13:42:46 [6002]   DEBUG:  exit(2)
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: Startup proc 6002 exited wit
##############################

TIA, Auri

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

Hi Tom & pg_list,

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

mmm, yes the postmaster was running in foregroud and was interrupted by a
CTRL+C....

What's the correct way to shutdown? kill -15 I think...

> 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.

pg_resetxlog.... mmm I've to read something about this command! U think
this is the solution?

TIA, Auri

Always me... ;P

I've just recover my installation by using pg_resetxlog.

But, what is the operation made by this command? I believe it performs a
reset to the previous checkpoint, so some data could be lost..

From now I'll use the start/stop/status script that I've found in
contrib/start_script dir!

Auri