Thread: pg_dumpall and large objects

hi,

the man page says pg_dump cannot dump "large objects".
can some one help me on what does this realy mean? how
large is large? if we have some icons can we still use
pg_dumpall to backup the db?

also large objects do not include large strings,
right?

thanks

cheng


=====
Best wishes
Z C Wang





____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

zhicheng wang wrote:
> hi,
>
> the man page says pg_dump cannot dump "large objects".
> can some one help me on what does this realy mean? how
> large is large? if we have some icons can we still use
> pg_dumpall to backup the db?

Large objects are items stored using the lo_xxx functions. Text fields
of any size are dumped as normal.

--
   Richard Huxton
   Archonet Ltd