Article ID: 6067, created on Feb 21, 2009, last review on Aug 14, 2016

  • Applies to:
  • H-Sphere


Sometimes the transaction log files become corrupted or deleted due to hordware crash, orpower failure, usually the error is like folowing:

hsphere=# select * from TABLE;
ERROR:  could not access status of transaction 1918986094
DETAIL:  could not open file "/var/lib/pgsql/data/pg_clog/0726": No such file or directory


The needed file should be reacreated manually with blanked inside, but filesize should be the same, so the /var/lib/pgsql/data/pg_clog/0726 should be created this way:
su - postgres
dd if=/dev/zero of=/var/lib/pgsql/data/pg_clog/0726 bs=256k count=1

Usually several files become broken and you need to recreate all of them.

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF