DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.

From: Olga Vingurt <olgavi(at)checkpoint(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: Ofer Israeli <oferi(at)checkpoint(dot)com>
Subject: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Date: 2012-07-16 12:14:52
Message-ID: A305A29309C1274FAA7A0FED4F1F75666EBFF0B313@il-ex01.ad.checkpoint.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are using PostgreSQL 8.3 on Windows Server.
The db crashed and now it fails to start up.

The error is:
FATAL: could not access status of transaction 4020264
DETAIL: Could not read from file "pg_clog/0003" at offset 212992: No error.

Additional log from event viewer:
LOG: database system was interrupted; last known up at 2012-07-12 11:35:00 CEST

How can we recover from the current state?

Thanks,
Olga

Responses

Browse pgsql-general by date

  From Date Subject
Next Message raghu ram 2012-07-16 13:55:56 Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Previous Message Nicolau Roca 2012-07-16 11:52:53 Replication terminated by primary server