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