I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing transaction id wraparound. I plan to pg_dump the database and initdb and reload. I may reload into an 8.1 database at this time.
I am curious how to make sure that I indeed get all the data out of the tables from a pg_dump. I want to ensure that there would not be anything "hidden" by the transaction id wraparound failure.
My current plan is selectively dump a portion of the data (most current, organized in tables by date ex xxx_2006_may) and reload. I plan to vaccuum each table before dumping. Please warn me if this is not enough. Any assistance is greatly appreciated.