Re: Fwd: corrupted files
| От | raghu ram |
|---|---|
| Тема | Re: Fwd: corrupted files |
| Дата | |
| Msg-id | CALnrrJRmY6xm0uCb9BaM410KGW2wyan7GqqBXCPboJBoKLwQ9w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Fwd: corrupted files (Klaus Ita <klaus@worstofall.com>) |
| Ответы |
Re: Fwd: corrupted files
|
| Список | pgsql-general |
On Tue, Jul 30, 2013 at 4:07 AM, Klaus Ita <klaus@worstofall.com> wrote:
Sorry for cross-posting, i read that pg-bug was not the right place for this emailHi 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 83934772013-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
В списке pgsql-general по дате отправления: