pg_dumpall and large objects

[zhicheng wang]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Richard Huxton]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Richard Huxton]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster