| 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!
| 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 |