Magnus Hagander <[EMAIL PROTECTED]> writes: > On Sun, Oct 21, 2007 at 04:24:05PM -0400, Tom Lane wrote: >> I'm pretty uncomfortable with the notion of having pg_dump deliberately >> throw data away. Another problem is that even if we did that, it would >> only help people who dumped their old DB with 8.3 pg_dump.
> Don't we already say you should use 8.3 pg_dump to dump your old db when > upgrading? We recommend that, but we've never required it, and in a lot of scenarios it's not all that practical to expect people to do that. In any case it would be more sensible to put the functionality in pg_restore, if we were going to do any such thing. What I'm more worried about is that none of the proposed solutions will help someone with a pg_dumpall dump, since that will be a flat SQL script ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings