Re: pg_dump and BINARY mode COPY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump and BINARY mode COPY
Date
Msg-id 17899.1196965339@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and BINARY mode COPY  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: pg_dump and BINARY mode COPY  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.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.

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #3799: csvlog skips some logs
Next
From: Bruce Momjian
Date:
Subject: Going to Japan