Kevin Kofler wrote:
PostgreSQL requires manual intervention at each upgrade (dump BEFORE you upgrade, restore afterwards)
As of PostgreSQL 9.0, there is an upgrade utility[1] that doesn't require a dump/restore. I have used it to go from 8.4 to 9.0 and now 9.0 to 9.1 without an issue.
[1] http://www.postgresql.org/docs/9.1/static/pgupgrade.html -- devel mailing list devel@xxxxxxxxxxxxxxxxxxxxxxx https://admin.fedoraproject.org/mailman/listinfo/devel
