"Ian Cass" <ian.cass@mblox.com> writes:
> FATAL 2: open of /var/lib/postgres/data/pg_clog/0534 failed: No such file
> or directory
We have seen a couple reports like this one, eg
http://archives.postgresql.org/pgsql-general/2002-03/msg00179.phphttp://archives.postgresql.org/pgsql-novice/2002-06/msg00027.php
It could be that all of you have been bitten by hardware problems
(viz, dropped bits in xmin/xmax fields), or there might be some
software bug that's leading to this failure. So far, no one's
been very cooperative about digging into a failure case to try to
determine exactly what happened...
regards, tom lane