Re: pg_upgrade diffs on WIndows - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_upgrade diffs on WIndows
Date
Msg-id 50465A23.4030606@dunslane.net
Whole thread Raw
In response to pg_upgrade diffs on WIndows  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pg_upgrade diffs on WIndows  (Andrew Dunstan <andrew@dunslane.net>)
Re: pg_upgrade diffs on WIndows  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On 09/04/2012 03:09 PM, Andrew Dunstan wrote:
> I realized this morning that I might have been a bit cavalier in using
> dos2unix to smooth away differences in the dumpfiles produced by
> pg_upgrade. Attached is a dump of the diff if this isn't done,  with
> Carriage Returns printed as '*' to make them visible. As can be seen,
> in function bodies dump2 has the Carriage Returns doubled. I have not
> had time to delve into how this comes about, and I need to attend to
> some income-producing activity for a bit, but I'd like to get it
> cleaned up ASAP. We are under the hammer for 9.2, so any help other
> people can give on this would be appreciated.
>


Actually, I have the answer - it's quite simple. We just need to open
the output files in binary mode when we split the dumpall file. The
attached patch fixes it. I think we should backpatch the first part to 9.0.

cheers

andrew

Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [PATCH] XLogReader v2
Next
From: Alvaro Herrera
Date:
Subject: Re: build farm machine using mixed results