Thread: 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?
Best,
Mina
2016-02-10 19:49 GMT+01:00 Mina Soltangheis <mina.soltangheys@gmail.com>:
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.
--
The standard question here is are you A: Running on Windows and B: using an antivirus? If so, it's often the antivirus getting in the way. Either turn it off or figure out how to exclude postgresql's files from it's view.
Hi,
Sorry for forgetting to add this info in the beginning.
Best,
Mina
On Mon, Feb 15, 2016 at 5:19 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
The standard question here is are you A: Running on Windows and B:
using an antivirus?
If so, it's often the antivirus getting in the way. Either turn it off
or figure out how to exclude postgresql's files from it's view.