Re: Could not open file pg_clog , Please help!

2016-02-10 19:49 GMT+01:00 Mina Soltangheis <mina(dot)soltangheys(at)gmail(dot)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 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.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com