On 16 Apr 2011, at 22:10, Edison So wrote:
> One response told me to try backing up 8.1 database using 9.0 pg_dump and restore it to 9.0 database using 9.0
pg_restore.
You shouldn't try to restore into a newer database version with a dump made with an older pg_dump. Pg_dump isn't (and
can'tbe) forward compatible to database versions that don't yet exist when it is released.
*Always* use a dump made with pg_dump from the newer database if you're upgrading. Especially between major versions of
thedatabase.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4da9fae2651344328412467!