"Mark Steben" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings