Re: Updating large postgresql database with blobs

CAJ CAJ wrote:
>
>
> Thanks for the response. This'd be wonderful if I can get my process
> right. My assumptions (probably incorrect) are that pgdump has to be
> excuted twice on a database with blobs. Once to get the data and once
> to get the blob (using the -b flag).
>
>

Why do you assume that? The pg_dump manual says:

-b
--blobs

Include large objects in the dump. This is the default behavior
except when --schema, --table, or --schema-only is specified, so the
-b switch is only useful to add large objects to selective dumps.

IOW, in most cases you will just get the large objects for free, and
don't even need to use this flag to get them. No need to run twice.

cheers

andrew