When moving or doing an upgrade of a PostgreSQL database that requires you to do a dump of the database, make sure you use the version of pg_dump that matches the version of the PostgreSQL database you plan on restoring the dump to. Different versions of pg_dump will dump the contents of a database in a different order then another version. Thus when restoring a database you will get a number of errors. This is common occurrence between PostgreSQL 7 and PostgreSQL 8. In addition, newer versions will have bug fixes that older versions will not have. Note, the same goes for pg_dumpall.

You should also make sure if you are doing backups with pg_dump or pg_dumpall, that you are using the matching version to your planned recovery site's database. Otherwise, you will have a great time restoring the backup!