pg_clog problem (PG version 7.4.5)

From: "Jim Buttafuoco" <jim(at)contactbda(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_clog problem (PG version 7.4.5)
Date: 2005-01-22 14:35:02
Message-ID: 20050122143155.M25644@contactbda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hackers,

I am having a problem with table (identified by pg_dump). I get the follow error when I try to COPY the table to
stdout (or /dev/null).

DB=# copy rnk to '/dev/null';
ERROR: could not access status of transaction 1076101119
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0402": No such file or directory

Pg version is
select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-6sarge1)

I do have a good backup from the day before, if needed. is there a magic command to get me out of this?

Thanks
Jim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Buttafuoco 2005-01-22 14:58:00 Re: pg_clog problem (PG version 7.4.5)
Previous Message Peter Eisentraut 2005-01-22 14:31:39 Re: [HACKERS] %2$, %1$ gettext placeholder replacement is not working under Win32