Postgres Pro
Downloads
Home   >   mailing lists

Could not open file pg_clog , Please help! - Mailing list pgsql-admin

From Mina Soltangheis
Subject Could not open file pg_clog , Please help!
Date
Msg-id CABWfiYwkgAMoMC9hs2kJ+65wO15Ew-Hz1Gfft-iNHnLXN4YRCw@mail.gmail.com
Whole thread Raw
Responses Re: Could not open file pg_clog , Please help!  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Could not open file pg_clog , Please help!  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: kwfarrell
Date:
Subject: Re: A local replication entry
Next
From: Guillaume Lelarge
Date:
Subject: Re: Could not open file pg_clog , Please help!