"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

Reply via email to