Re: Could not open file pg_clog , Please help!

Hi, 

I made a database which was perfectly working. I used to work with only one of the tables in the data base and it works fine, but now that I want to use another tables it gives me this error: 

ERROR: could not access status of transaction ######      DETAIL: could not open file "pg_clog/####": No such file or directory

I have no backups of the database and I am not sure if I could run queries on other tables even in the beginning (so maybe the issue was there from the beginning.) at the moment I only have one file in pg_clog directory which is 0000 .

Any suggestions how to fix this?