Re: select failure

"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.php
http://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