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