Database corruption.

From: Michael Guerin <guerin(at)rentec(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Database corruption.
Date: 2007-02-07 21:18:50
Message-ID: 45CA423A.2060804@rentec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Our database filled up and now I'm getting this error on one of the
tables. Is there any way to recover from this? Please let me know if
more information is needed.

pg_version version
--------------------------------------------------------------------------------
PostgreSQL 8.1RC1 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.0.1
(1 row)

I've restarted the database and drop the index on the table, recreating
gives me the same error:

db1=# create index idx_timeseries on tbltimeseries(timeseriesid)
tablespace tblspc_index;
ERROR: could not access status of transaction 3376354368
DETAIL: could not open file "pg_clog/0324": No such file or directory
db1=#

-Michael

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Guerin 2007-02-07 21:56:01 Re: Database corruption.
Previous Message Joshua D. Drake 2007-02-07 19:39:13 Re: Postgres training down under.