Thread: Error in restoring a large object
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
Chris McCormick <mccormick1@gmail.com> writes: > 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: How many is "many"? > 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)? Try looking into the postmaster log to see if there's any corresponding failure logged on the server side. regards, tom lane