Re: invalid data in file backup_label problem on windows

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: invalid data in file backup_label problem on windows
Дата
Msg-id f30cb00a-aceb-bbec-dd15-46533cabe932@dunslane.net
обсуждение исходный текст
Ответ на Re: invalid data in file backup_label problem on windows  (David Steele <david@pgmasters.net>)
Ответы Re: invalid data in file backup_label problem on windows  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On 3/26/21 2:45 PM, David Steele wrote:
> On 3/26/21 1:20 PM, Magnus Hagander wrote:
>> On Fri, Mar 26, 2021 at 5:52 PM Andrew Dunstan <andrew@dunslane.net>
>> wrote:
>>> 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.
>>
>> Yeah, it seems a bit imprecise. Maybe something like "which includes
>> things like opening the file in binary mode"? (I want the "includes"
>> part because it also means other things, this is not the only thing).
>
> OK, how about the attached?
>
>

-     vital to the backup working, and must be written without modification.
+     vital to the backup working and must be written without
modification, which
+     may include opening the file in binary mode.


how about


... must be written byte for byte without modification, which might
require opening the file in binary mode.


cheers


andrew

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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Idea: Avoid JOINs by using path expressions to follow FKs
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Idea: Avoid JOINs by using path expressions to follow FKs