Mahlon E. Smith wrote: >+1 for pg_upgrade. Make sure you're using 9.0.4's version, there was a
Having had to write my own tools to recover a database where the transaction log partition was gone last January, I can vouch for the robustness of the format with which the database records are stored. Converting it from one version to the next should be fairly straightforward. So I'd guess (without checking the source) that the pg_upgrade path is relatively safe and robust. -- Stephen. Heisenberg might have been here.
