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

From Simon Riggs
Subject Re: pg_dump and BINARY mode COPY
Date
Msg-id 1196964452.4255.430.camel@ebony.site
Whole thread Raw
In response to Re: pg_dump and BINARY mode COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump and BINARY mode COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 2007-12-06 at 12:43 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] BUG #3799: csvlog skips some logs
Next
From: Andrew Dunstan
Date:
Subject: Re: [BUGS] BUG #3799: csvlog skips some logs