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>.