Hi all, I'm about to
upgrade from 7.1.3 to 7.3.2, and I'm going through the upgrade document right
now. Since I'm not a DBA - I'm just a sys-admin - I'm not really sure what
to make of the following option during the backup part of the
upgrade:
"If you need to
preserve OIDs (such as when using them as foreign keys)k then use the -o option
when running pg_dumpall. pg_dumpall does not save large
objects."
I have no idea
whether I'm using OIDs - I do know I made two dumps of the database, and one was
84 megs, the other 94 (with/without -o, respectively). The database is
used in conjunction with Lyris ListManager, and to my knowledge no custom SQL
work has been done on it.
Thanks for any help,
and any additional tips on pitfalls to avoid during my
upgrade!
Jeff