error restoring large objects during pg_restore
От | Ron Snyder |
---|---|
Тема | error restoring large objects during pg_restore |
Дата | |
Msg-id | F888C30C3021D411B9DA00B0D0209BE803BBA621@cvo-exchange.cvo.roguewave.com обсуждение исходный текст |
Ответы |
Re: error restoring large objects during pg_restore
|
Список | pgsql-general |
I'm trying to pg_restore a database using a process that I've used a bunch (10-15) times in the past, and this is the first time it's ever failed on me. It's failing with the following error: [snip] pg_restore: creating table for large object cross-references pg_restore: [custom archiver] could not read data block - expected 1, got 0 pg_restore: *** aborted because of error When I look in the logs, I see the following: [snip] Jun 10 14:24:19 vault pgqv[16995]: [242519] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898427, 60983741); Jun 10 14:24:19 vault pgqv[16995]: [242520] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898503, 60983743); Jun 10 14:24:19 vault pgqv[16995]: [242521] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898534, 60983745); Jun 10 14:24:19 vault pgqv[16995]: [242522] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898544, 60983747); Jun 10 14:24:19 vault pgqv[16995]: [242523] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898552, 60983749); Jun 10 14:24:19 vault pgqv[16995]: [242524] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898564, 60983751); Jun 10 14:24:19 vault pgqv[16995]: [242525] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898570, 60983753); Jun 10 14:24:19 vault pgqv[16995]: [242526] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898584, 60983755); Jun 10 14:24:19 vault pgqv[16995]: [242527] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (57898592, 60983757); Jun 10 14:24:19 vault pgqv[16995]: [242528] DEBUG: query: Insert Into dump_blob_xref(oldOid, newOid) Values (1, 60983759); I've done this twice, with two different db dumps, and both have given me the same error. I'm wondering if that last line (with the oldOid value of 1) is significant. Thoughts, ideas? -ron
В списке pgsql-general по дате отправления: