Hello Alban, Thank you for the suggestion.
May I ask you and others another advice as to taking a Postgres course? I am not a DBA and have never taken a database course. However, I am using Postgres for a system I am supporting. Any suggestion? I need to set up a primary-standby or load-balancing Postgres system for disaster recovery. Thanks in advance. I would like to take an instructor-led Postgres 9.0 course which includes database administration and replication with Slony. On Sat, Apr 16, 2011 at 4:23 PM, Alban Hertroys < dal...@solfertje.student.utwente.nl> wrote: > 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't be) 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 the database. > > Alban Hertroys > > -- > If you can't see the forest for the trees, > cut the trees and you'll see there is no forest. > > > !DSPAM:1251,4da9fad7651346015739574! > > > -- Edison
