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?
Best,
Mina