Home > mailing lists

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

From	Richard Sydney-Smith
Subject	Ooops ! :( Recovery techniques
Date	December 1, 2003 03:42:18
Msg-id	017b01c3b7c5$7328cd40$61c58690@athlon2000 Whole thread Raw
Responses	Re: Ooops ! :( Recovery techniques
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 then tells me that a file /data/pg_clog/0697 is not there.

I presume that these are the transaction log files.

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

From: "Iain"
Date: 01 December 2003, 02:12:44
Subject: Re: Bug: Sequence generator insert

From: "Kumar"
Date: 01 December 2003, 11:04:59
Subject: Concatenating multiple fetches into a single string