Re: Fwd: corrupted files

Hi!

Thank you, I actually tried that and it seems that only lead to even more
corrupted data. I am currently trying to recover the 'hot-standby' host
that is also unhappy about one of the wal_files. I am looking at the wal
with less and see only data i do not care about in it (mostly
session-logging/statistics data).

I am trying to remember, there was a tool that plotted the contents of the
wal_files in a more readable format ...

lg,k

On Tue, Jul 30, 2013 at 8:23 AM, raghu ram <raghuchennuru(at)gmail(dot)com> wrote:

>
> On Tue, Jul 30, 2013 at 4:07 AM, Klaus Ita <klaus(at)worstofall(dot)com> wrote:
>
>> Sorry for cross-posting, i read that pg-bug was not the right place for
>> this email
>>
>> Hi list!
>>
>> depressed me gets error messages like these:
>>
>> 2013-07-29 20:57:09 UTC <xaxos_mailer%xaxos_de> ERROR: could not access
>> status of transaction 8393477
>> 2013-07-29 20:57:09 UTC <xaxos_mailer%xaxos_de> DETAIL: Could not open
>> file "pg_clog/0008": No such file or directory.
>>
>> combined with the error output of queries that do not work.
>>
>> I looked in pg_clog and correct, 0008 is missing.
>>
>>
>>
> You can recreate a missed "pg_clog" file with below command:
>
> dd if=/dev/zero of=~/9.1/main/pg_clog/0008 bs=256k count=1 (To make the
> uncommitted record as they haven't been committed.)
>
> and then try to start the cluster.
>
> Thanks & Regards
> Raghu Ram
>
>