I am receiving an error when running a pg_dump. These are older legacy systems and upgrading them is not in plan. Any help will be appreciated.
CentOS 5.3 (64bit) psql (PostgreSQL) 8.3.11 full error message: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not access status of transaction 3101708884 DETAIL: Could not open file pg_clog/0B8E: No such file or directory. pg_dump: The command was: COPY blob_store.blobs (blob_id, mime_type, binary_data, create_ts) TO stdout; Command used, pretty standard pg_dump -Fc <dbname> -f <outfile> TIA, Jesse Waters -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
