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