From: | Edison So <edison(dot)so2(at)gmail(dot)com> |
---|---|
To: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
Cc: | pasman pasmański <pasman(dot)p(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: New feature: selectivity - new attribute in function |
Date: | 2011-04-16 20:48:58 |
Message-ID: | BANLkTik9b5O0-qaJ_n0m4remeXeNsPoWng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)solfertje(dot)student(dot)utwente(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-04-16 20:50:33 | Re: New feature: selectivity - new attribute in function |
Previous Message | Alban Hertroys | 2011-04-16 20:23:45 | Re: New feature: selectivity - new attribute in function |