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?
You should probably give the full error message (I mean, with no redaction). It would help us give a definitive answer.