Mason Hale wrote:
From what I've read about postgres 8.2, upgrading from any previous
version requires a full database dump and restore.
I am working with largish database (~70GB) that I would like to
upgrade to 8.2.
A full database dump currently takes ~3 hrs, I expect a restore
require a similar timeframe if not more.
So, I'm fishing to see of there are alternatives to taking our
production database down for 6+ hours do this upgrade.
Check out <a
href="http://pgfoundry.org/projects/pg-migrator/";>pg_migrator</a>.
