30.01.2013, 18:47, "Jeff Janes" <jeff.janes@xxxxxxxxx>:
> You would probably want to use the pg_dump from 9.2, as there are
> improvements in that version of pg_dump to speed up partial dumps.
> You can use pg_dump from 9.2 against server 9.0 and still get the
> improvements. But that means you should be upgrading to 9.2 rather
> than 9.1. (Which you should probably do anyway unless you have a
> specific reason not to.)
Now think about it. Try to make 9.0 -> 9.2 -> 9.1 ?
Downgrading is generally not supported. Why not just stick with 9.2 as the end target? If you really need 9.1, I would not entertain the thought of using 9.2's pg_dump and then trying to go backwards, at least not until I tried 9.1's dump and proved that it was a serious bottleneck.
Cheers,
Jeff
