From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
---|---|
To: | Klaus Ita <klaus(at)worstofall(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fwd: corrupted files |
Date: | 2013-07-30 06:23:25 |
Message-ID: | CALnrrJRmY6xm0uCb9BaM410KGW2wyan7GqqBXCPboJBoKLwQ9w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Klaus Ita | 2013-07-30 06:50:40 | Re: Fwd: corrupted files |
Previous Message | Klaus Ita | 2013-07-29 22:37:27 | Fwd: corrupted files |
From | Date | Subject | |
---|---|---|---|
Next Message | Klaus Ita | 2013-07-30 06:32:59 | Recovery failure |
Previous Message | Raghavendra | 2013-07-30 06:21:35 | Re: how to get UPDATEXML function in postgresql as it works in oracle |