Re: New feature: selectivity - new attribute in function

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