Alain BAUDHUIN wrote: > I'm surprised, though not to find any pg_dump switch to produce a > v7.x compatible dump. Did I look at the wrong place ? Does anybody > know about the right way to dump a database in a cross-version > compatible form ?
Downgrades are generally not supported. You may be able to convince the older pg_dump to dump the newer database but I don't expect that to work very well either. The best bet is probably to use the new pg_dump and manually fix up the dump for 7.3. > NB: I expect this issue is fairly common for people who, like me, run > their development server on Windows (ie. v 8+) and have their > application hosted at a provider who keeps delaying its upgrade from > v7 to v8... This sort of thing is a recipe for desaster for more reasons than this one. Developing on version X gives no guarantees that deploying on version Y will work. Btw., speaking of "v7" and "v8" is about as useful and specific as talking about Linux 1 and Linux 2. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
