"Mark Steben" <msteben@xxxxxxxxxxxxxxx> 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
