I just upgraded to 7.4.6 and have the same error message.
---------- Original Message -----------
From: "Jim Buttafuoco" <jim@contactbda.com>
To: "pgsql-hackers" <pgsql-hackers@postgresql.org>
Sent: Sat, 22 Jan 2005 09:35:02 -0500
Subject: [HACKERS] pg_clog problem (PG version 7.4.5)
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
------- End of Original Message -------