On 04/24/2013 03:35 AM, jesse.wat...@gmail.com wrote:
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.

Does the above file actually exist in the pg_clog 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




--
Adrian Klaver
adrian.kla...@gmail.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to