Re: BLOBs, pg_dump & pg_restore

Howard Lowndes <lannet@lannet.com.au> writes:
> When you dump a database with the BLOBs, even with the -c option, and then
> restore that database again with the -c option, you get double the BLOBs.
> The original BLOBs are there as are the new copies, and the cross
> referenced oids are updated.

Yeah.  I don't believe "-c" causes anything much to be done with BLOBs.
It would be fairly risky to try, since the premise of "-c" is that you
don't want the *whole* database wiped out, only the objects you are
replacing.  I'd worry about zapping BLOBs that are still referenced
elsewhere ...

            regards, tom lane