pgdump error "Could not open file pg_clog/0B8E: No such file or directory"

From: jesse(dot)waters(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: pgdump error "Could not open file pg_clog/0B8E: No such file or directory"
Date: 2013-04-24 10:35:47
Message-ID: CAL0F7nc5WoPFxgP6VZjtUNP4=35FLsE9WAuJb7R6EPSnaFXzAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2013-04-24 11:00:44 Re: run COPY as user other than postgres
Previous Message Manning John 2013-04-24 08:33:27 Re: Regression test fails v9.2.4