Re: ERROR: could not access status of transaction - Mailing list pgsql-admin

From Stevie
Subject Re: ERROR: could not access status of transaction
Date
Msg-id 1301043004.2357.8.camel@stevie
Whole thread Raw
In response to Re: ERROR: could not access status of transaction  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-admin
Hello

> There is a commit log corruption in your database.

Yes, and it seems this is produce by a pg_upgrade bug from pg8 to pg9 in
October 2010.
> You need to make the files with right size (256K of zeroes).A suitable
> "dd" from /dev/zero will accomplish this on modernUnixen (ie, anything
> that has /dev/zero). Filling of those files with zeroes nothing but  "
> all those old transactions are aborted".

I was able to restore these files from backup. The dump is finished
without errors.

This corruption is just on our master replication, which was upgraded.
Is it a good idea to restore the clog files there too?

Regards
Steffen



pgsql-admin by date:

Previous
From: Simon
Date:
Subject: Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Next
From: Simon Riggs
Date:
Subject: Re: ERROR: could not access status of transaction