Re: New feature: selectivity - new attribute in function

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Edison So <edison(dot)so2(at)gmail(dot)com>
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:23:45
Message-ID: 4F603329-5200-45A1-8B16-66B205802EE5@solfertje.student.utwente.nl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:737,4da9fae2651344328412467!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edison So 2011-04-16 20:48:58 Re: New feature: selectivity - new attribute in function
Previous Message Edison So 2011-04-16 20:10:39 Re: New feature: selectivity - new attribute in function