"Mark Steben" <msteben@autorevenue.com> writes:
> Thanks Tom - that did the trick
In that case, you were missing pg_database and probably other system
catalogs too in your vacuuming.
> We will be upgrading to 8.2 within the next couple weeks.
I'd recommend making sure you have vacuumed all system catalogs before
you try to pg_dump, else some of the catalog entries may be invisible
to pg_dump :-(
FWIW, 8.2 should be proof against this type of problem recurring,
because it takes proactive steps to avoid transaction ID wraparound.
7.4 left that up to the DBA ...
regards, tom lane