Error in restoring a large object

From: Chris McCormick <mccormick1(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error in restoring a large object
Date: 2011-07-17 11:44:00
Message-ID: CAGvt1sE+wTHoKa+sGFh-JbbiBV1j8rEZLEqkMDhgpc+mDGs+hQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,
I am testing a backup and restore of a db in version 7.4.30. During the
restore, after successfully restoring many BLOBS, I get the following error:

pg_restore: restoring large object OID 318907
pg_restore: restoring large object OID 318909
pg_restore: restoring large object OID 318911
pg_restore: [archiver] could not write to large object (result: 4294967295,
expected: 32768)
pg_restore: *** aborted because of error

What does it mean that the archiver "could not write" to the large
object? How can I find out more information about the object in question
(and possibly delete it)?

Thanks,
Chris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-07-17 15:17:06 Re: Error in restoring a large object
Previous Message Craig Ringer 2011-07-17 11:19:12 Re: "FATAL: role "postgres" does not exist" after recover