On Thu, 2007-12-06 at 12:43 -0500, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > Is there a reason why pg_dump avoids using BINARY mode COPY?
>
> To preserve platform and version independence of the dump.
OK, thats what I guessed.
> > Unless there is a specific reason not to we could/should allow an option
> > on the dump.
>
> Is there any evidence to show that there'd be enough benefit to warrant
> taking such a risk with your dumps?
Only if there is a risk. Since a common route to upgrade is a
dump/restore back onto same box it seems worth having an option to do
this.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com