Re: Ooops ! :( Recovery techniques

> 
> My machine just crashed in the middle of an update.
> 
> When I restart the postgresql server the database engine appears ok and the=
> n tells me that a file /data/pg_clog/0697 is not there.=20
> 
> I presume that these are the transaction log files.=20
> I would like to truncate the old logfiles, re-index and keep going.
> I that possible with postgres of do I have to do a full rebuild?
> 
> thanks verymuch
> 
> Richard Sydney-Smith
> 
> 
Sorry, your presumption is wrong. In contrary to what the name might 
suggest this file is not a log file at all. 
Your dbase is probably seriously damaged. 
If you haven't made a dbase dump using "pg_dump" before, 
you'd better do that full rebuild you mentioned. 

Regards, Christoph 

PS I recommend to read the chapter 'Backup and Restore' of the 
fine manual to be prepared when your machine crashes again.