Postgres Pro
Downloads
Home   >   mailing lists

Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error. - Mailing list pgsql-general

From Raghavendra
Subject Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Date
Msg-id CA+h6Ahg8P6T1cXeRzEfJ41pibR0QjK7uZHwdm9-fQm=X7oK7fA@mail.gmail.com
Whole thread Raw
In response to Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-general
Tree view
I think you need to download windows version DD and use it.

---
Regards,
Raghavendra
EnterpriseDB Corporation



On Mon, Jul 16, 2012 at 7:25 PM, raghu ram <raghuchennuru@gmail.com> wrote:


On Mon, Jul 16, 2012 at 5:44 PM, Olga Vingurt <olgavi@checkpoint.com> wrote:

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?

 



Please perform below steps:

1. Backup the current pg_clog/0003 file in different directory

2. Create a file by assumption of  make the uncommitted record as they haven't been committed. command as follows:

dd if=/dev/zero of=<data directory location>/pg_clog/0003   bs=256K count=1 

3. Start the Cluster


--

Thanks & Regards,

Raghu Ram

EnterpriseDB Corporation

Blog:http://raghurc.blogspot.in/




pgsql-general by date:

Previous
From: raghu ram
Date:
Subject: Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Next
From: Craig Ringer
Date:
Subject: Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)