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
<dalroi@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
