Re: ftell mismatch with expected position

>
> 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