Re: Ooops ! :( Recovery techniques - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Ooops ! :( Recovery techniques
Date
Msg-id 200312021525.QAA18638@rodos
Whole thread Raw
In response to Ooops ! :( Recovery techniques  ("Richard Sydney-Smith" <richard@ibisaustralia.com>)
List pgsql-sql
> 
> 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. 



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with intervals
Next
From: Stephan Szabo
Date:
Subject: Re: Validity check in to_date?