Re: Corrupted Data?

Alvaro Herrera wrote:
> On Tue, Sep 14, 2004 at 08:13:24AM -0400, Matthew T. O'Connor wrote:
> You can create a pg_clog file (the one it's complaining about) filled
> with zeros, using
> dd if=/dev/zero bs=1k count=8 of=/path/to/data/pg_clog/0E3D

Ok, I tried this, and it changed the error but hasn't fixed the problem
now I get this:

[dbmail2@dezeut dbmail2]$ psql
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
dbmail2=# delete from messageblks where messageblk_idnr = 7718;
ERROR:  could not access status of transaction 3822646358
DETAIL:  could not read from file "/var/lib/pgsql/data/pg_clog/0E3D" at
offset 139264: Success

And in the log file I get this:

ERROR:  XX000: could not access status of transaction 3822646358
DETAIL:  could not read from file "/var/lib/pgsql/data/pg_clog/0E3D" at
offset 139264: Success
LOCATION:  SlruReportIOError, slru.c:634

Any more thoughts?

Thanks again,

Matthew