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

On Mon, Jul 16, 2012 at 5:44 PM, Olga Vingurt <olgavi(at)checkpoint(dot)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/