| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Chris McCormick <mccormick1(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Error in restoring a large object |
| Date: | 2011-07-17 15:17:06 |
| Message-ID: | 12075.1310915826@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Chris McCormick <mccormick1(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mdxxd | 2011-07-18 01:37:52 | Building an home computer for best Poker Tracker performance |
| Previous Message | Chris McCormick | 2011-07-17 11:44:00 | Error in restoring a large object |