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