Re: pg_dump and BINARY mode COPY

I use often pgdump... and we have many bytea on our database...<br /> Without binary COPY, backup is very slow and
takes4x more space on the network wire...<br /><br /> It would be great to have an option (--binary) with eventually a
WARNINGmessage (that your backup could be not portable across architecture...)<br /> but i think that 99% of the time
wedon't change between x86 or ppc....<br /><br /> please think for users...<br /> Hubert<br /><br /> Le jeudi 06
décembre2007 à 18:32 +0000, Simon Riggs a écrit : <blockquote type="CITE"><pre>
 
<font color="#000000">On Thu, 2007-12-06 at 13:22 -0500, Tom Lane wrote:</font>
<font color="#000000">> Simon Riggs <<a href="mailto:simon@2ndquadrant.com">simon@2ndquadrant.com</a>>
writes:</font>
<font color="#000000">> > On Thu, 2007-12-06 at 12:43 -0500, Tom Lane wrote:</font>
<font color="#000000">> >> To preserve platform and version independence of the dump.</font>
<font color="#000000">> </font>
<font color="#000000">> > Only if there is a risk. Since a common route to upgrade is a</font>
<font color="#000000">> > dump/restore back onto same box it seems worth having an option to do</font>
<font color="#000000">> > this.</font>
<font color="#000000">> </font>
<font color="#000000">> I think you missed the point about version independence.  That would be</font>
<font color="#000000">> exactly the scenario where a version-to-version change in binary format</font>
<font color="#000000">> --- for instance, "money" widening to 64 bits in 8.3 --- would burn you.</font>

<font color="#000000">OK</font>

<font color="#000000">> Furthermore, this doesn't seem like a scenario where performance ought</font>
<font color="#000000">> to be the primary concern.  How often do you do major version upgrades?</font>

<font color="#000000">Not often enough.</font>

<font color="#000000">If it was faster, we would rely on more people actually doing it.</font>

</pre></blockquote><br /> _________________________________________________ <br /> Ce message et les éventuels
documentsjoints peuvent contenir des informations confidentielles. Au cas où il ne vous serait pas destiné, nous vous
remercionsde bien vouloir le supprimer et en aviser immédiatement l'expéditeur. Toute utilisation de ce message non
conformeà sa destination, toute diffusion ou publication, totale ou partielle et quel qu'en soit le moyen est
formellementinterdite. Les communications sur internet n'étant pas sécurisées, l'intégrité de ce message n'est pas
assuréeet la société émettrice ne peut être tenue pour responsable de son contenu.