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

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:

• postresql: move data directory to another location
• how to restore postgreSQL database with template using pg_dump
• postgresql: how to reset forgotten postgres password
• How to change Porstgresql default password
• how to install PostgreSQL 12 on Ubuntu / Debian 10,11