Network Administrator <netadmin@vcsn.com> writes:
> ..if I using the psql client, and issue a "select * from <corrupt table name>
> limit 5" if get this...
> PANIC: read of clog file 5, offset 16384 failed: Success
Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names
and sizes)?
> So back to my original question. What are the recover procedures (if
> any) that should be tried before I grab my PGDATA path from tape?
You may be up against having to do that, but some investigation first
seems called for.
regards, tom lane