| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | richard(at)ibisaustralia(dot)com (Richard Sydney-Smith) |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Ooops ! :( Recovery techniques |
| Date: | 2003-12-02 16:25:51 |
| Message-ID: | 200312021525.QAA18638@rodos |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Smith | 2003-12-02 20:55:46 | Re: Problem with intervals |
| Previous Message | Stephan Szabo | 2003-12-02 16:15:24 | Re: Validity check in to_date? |