Still more pg_clog errors - Mailing list pgsql-general

From Steve Wolfe
Subject Still more pg_clog errors
Date
Msg-id 416D5F6D.30904@codon.com
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: GRANT cascade to implicit sequences
Next
From: Greg Stark
Date:
Subject: Re: Date format for bulk copy