Re: invalid data in file backup_label problem on windows - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: invalid data in file backup_label problem on windows
Date
Msg-id 3e3f377d-f91e-bd45-6c5c-08288b45b7e4@dunslane.net
Whole thread Raw
In response to Re: invalid data in file backup_label problem on windows  (David Steele <david@pgmasters.net>)
Responses Re: invalid data in file backup_label problem on windows  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On 3/26/21 10:19 AM, David Steele wrote:
>
>> No, the problem is you are using copy/paste and in doing so you are
>> *changing'* the value that is being returned. You'll either need to
>> update your copy/paste procedure to not mess with the newlines, or to
>> use a better way to get the data out.
>>
>> If we need to clarify that in the documentation, I'm fine with that.
>> Maybe add an extra sentence to the part about not modifying the output
>> to mention that this includes changing newslines and also encoding
>> (which would also break it, if you managed to find a non-ascii
>> compatible encoding). Maybe even something along the line of "the
>> contents have to be written in binary mode"?
>
> Perhaps something like the attached?
>
>


That seems a bit opaque.  Let's tell them exactly what they need to avoid.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: WIP: BRIN multi-range indexes
Next
From: Andres Freund
Date:
Subject: Re: wal stats questions