Home > mailing lists

Postgres recovery - Mailing list pgsql-cygwin

From	Richard Sydney-Smith
Subject	Postgres recovery
Date	December 1, 2003 01:09:34
Msg-id	002801c3b7b0$23b44650$61c58690@athlon2000 Whole thread Raw
List	pgsql-cygwin

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: "Dave Page"
Date: 30 November 2003, 20:00:42
Subject: Re: Error registering pg as a Windows Service

From: pgsql@b-great.net
Date: 01 December 2003, 07:21:21
Subject: Re: install problems with ipc-daemon2