On Saturday, April 16, 2011 2:06:44 pm Edison So wrote:
> Haha. Having a QA background for many years, I do not believe in anything
> until it is tested. :)
I have done it enough times to know it works. The issue that might arise are not
related to the pg_dump program but version changes in behavior. In your case
going from 8.1 to 9.0 goes through the stricter typing introduced in 8.3. The
data will restore to the new version but you may run into problems when you do
things in the database. Some time with the release notes for each version you
are going through would be instructive.
>
> Thanks.
Adrian Klaver
adrian.klaver@gmail.com