Re: [GENERAL] error opening pg_clog file

2004-10-13 Thread Tom Lane
Steve Wolfe <[EMAIL PROTECTED]> writes: >So, I did "dd if=/dev/zero of=/usr/local/pgsql/data/pg_clog/0089 > bs=8k count=1". I did an ls to verify that the file existed. I started > the postmaster back up, tried a VACUUM, and got: > vacuumdb: vacuuming of database "hyperseek" failed: ERROR:

[GENERAL] error opening pg_clog file

2004-10-12 Thread Steve Wolfe
On Saturday, our database machine locked up hard on us due to some faulty hardware. Since then, we have been getting messages like this: ERROR: could not access status of transaction 143934068 DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0089": No such file or directory L