Still more pg_clog errors

From: Steve Wolfe <nw(at)codon(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Still more pg_clog errors
Date: 2004-10-13 17:01:33
Message-ID: 416D5F6D.30904@codon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


In reference to the pg_clog errors I'm having, I am still looking for
tips or help. Here's the info again:

"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

Now, despite creating an 8k file of zeros (or a 256k file of zeros to
match the others in the directory), when I start the database and try a
vacuum, I get the same message, and upon inspection, the file is gone -
as if Postgres is removing the file.

Any tips or help on what I can do?

steve

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2004-10-13 17:04:57 Re: Date format for bulk copy
Previous Message Tom Lane 2004-10-13 16:55:50 Re: Proposal: GRANT cascade to implicit sequences