Postgres recovery

From: "Richard Sydney-Smith" <richard(at)ibisaustralia(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Postgres recovery
Date: 2003-12-01 02:08:49
Message-ID: 002801c3b7b0$23b44650$61c58690@athlon2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-cygwin by date

  From Date Subject
Next Message Grigoriy Puzankin 2003-12-01 07:54:20 Re: install problems with ipc-daemon2
Previous Message John Simeone 2003-12-01 00:12:49 HELP With Install 7.4.1 under Cygwin -