Hi all,
After a year or so of programming with it, I've become a serious Pg fan.
However, I have one quibble / query.
Many of my applications use large objects to store images, text chunks
etc. etc. This works very well, and certainly has adequate performance
for anything I've ever tried to do with it.
However, what rather terrifies me is that pg_dump seems only to store the
oid field in the dump, and not the content of the LO itself.
(Oh, I'm using PostgreSQL 6.5.2 at the moment, but will be upgrading into
the 7.x range shortly).
Of course, I could write a program to back up the full content of any
given database, but right now I can't think of a generalised way to do
this for any given DB.
So, does anyone know a solution? Or am I missing something? I get
nervous having production DBs which I can't back up.
Regards,
Hal