Re: Corrupted Data?

On Tue, Sep 14, 2004 at 08:01:13PM -0400, Matthew T. O'Connor wrote:
> 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

Huh, sorry, the directions only created the first block of the file, but
you needed the 17th ...

dd if=/dev/zero bs=8k count=17 of=/path/to/data/pg_clog/0E3D

I may be subject of a fencepost problem here, so if it doesn't work try
with 18.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Limítate a mirar... y algun día veras"