Re: pg_dump and BINARY mode COPY

On Thu, 2007-12-06 at 13:22 -0500, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > On Thu, 2007-12-06 at 12:43 -0500, Tom Lane wrote:
> >> To preserve platform and version independence of the dump.
>
> > 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.
>
> I think you missed the point about version independence. That would be
> exactly the scenario where a version-to-version change in binary format
> --- for instance, "money" widening to 64 bits in 8.3 --- would burn you.

OK

> Furthermore, this doesn't seem like a scenario where performance ought
> to be the primary concern. How often do you do major version upgrades?

Not often enough.

If it was faster, we would rely on more people actually doing it.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com