postgresql: Could not open file “pg_clog/0000”: No such file or directory

0
(0)

I am getting the error like following while accessing a Postgres database

ERROR:  could not access status of transaction 69675
DETAIL:  Could not open file "pg_clog/0000": No such file or directory.

 In the event where your data integrity isn’t as critical like a test database you can get away with creating empty files for the missing transaction logs like this:

dd if=/dev/zero of=/path/to/db/pg_clog/xxxx bs=256k count=1
chown postgres.postgres /path/to/db/pg_clog/xxxx
chmod go-rwX /path/to/db/pg_clog/xxxx

Similar Posts:

547

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top