Sorry for the delay. No it does not exist. ls -l /var/lib/pgsql/data/pg_clog/0B8E ls: /var/lib/pgsql/data/pg_clog/0B8E: No such file or directory Have 92 files in directory which are all 262144 in size. On Wed, Apr 24, 2013 at 9:23 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > On 04/24/2013 03:35 AM, jesse.waters@xxxxxxxxx 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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
