is there a good way to handle large objects when backing up a database? the
way it looks is that the large objects are external files on the file system
and are just pointed to by entries in the table. But it looks like when you
dump the database and then try to restore it, the object ids no longer synch
up.
It's been awhile since we had to deal with this problem but now I have to
create a backup plan. How do you properly back up tables with large objects
(for restoring, or for transferring database to a different server)?
--Doug
p.s. or am i missing something? or does recent versions of pgsql handle
this differently?
