Re: [ADMIN] unable to locate a valid checkpoint

2002-03-25 Thread Auri Mason
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_scr

Re: [ADMIN] unable to locate a valid checkpoint

2002-03-25 Thread Auri Mason
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 o

Re: [ADMIN] unable to locate a valid checkpoint

2002-03-22 Thread Tom Lane
Auri Mason <[EMAIL PROTECTED]> 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

[ADMIN] unable to locate a valid checkpoint

2002-03-22 Thread Auri Mason
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: f