Обсуждение: 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