2016-02-10 19:49 GMT+01:00 Mina Soltangheis <mina.soltangheys@xxxxxxxxx>:
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 directoryI 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.
--
