| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jim Nasby <decibel(at)decibel(dot)org> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-admin(at)postgresql(dot)org, Shane Ambler <pgsql(at)007marketing(dot)com>, Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, eddy(at)axa(dot)it |
| Subject: | Re: dump from 8.x restore to 7.3.x |
| Date: | 2006-12-05 16:00:08 |
| Message-ID: | 5258.1165334408@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Jim Nasby <decibel(at)decibel(dot)org> writes:
> On the other hand, dumping a newer version database with an older
> version of *pg_dump* is much more likely to succeed.
You meant to say that the other way around, no? Certainly for a jump
this big I'd rather expect the older pg_dump to fail altogether.
[ experiments a bit... ] Both 7.3 and 7.4 pg_dump fail to talk to an
8.1 server; they expect pg_database.datpath to exist. 8.0 pg_dump
seems to do OK with 8.1 ... has some problems with 8.2 though.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dev.department | 2006-12-05 16:01:17 | Hide structure |
| Previous Message | Edoardo Ceccarelli | 2006-12-05 12:33:18 | Re: dump from 8.x restore to 7.3.x |