Presumably it doesn't happen without the use of the pipe notation.
Indeed, it only happens when a pipe is involved.
I suspect that what's happening is that stdout isn't getting put into
binary mode, so that Microsoft's CR/NL translation corrupts the data.
If that's true, though, the resulting backup file should be corrupt;
is it valid according to "pg_restore backupfile"?
Yes pg_restore restores it without problems. However I did notice that it is larger then normal.
I have also tested what happens on freebsd when using a pipe and there are no warnings and backup is expected size.
I dug into the source code of pg_dump and found that the warning is given by _getFilePos(ArchiveHandle *AH, lclContext *ctx) in pg_backup_custom.c but it won't if ctx->hasSeek is set to false. Which is initialized by a call to checkSeek in pg_backup_archiver.c. Unfortunatly I'm not yet able to build and debug ton windows to verify if a correction to this function would help.
regards, Eelke
