Re: PostgreSQL Dump based backup using pipe - Mailing list pgsql-admin

girish R G peetle <giri.anamika0@gmail.com> writes:
> Thanks for checking. Here is the details.
> PostgreSQL Version - 9.2.8

Hm.  A quick trawl of the git logs didn't find any relevant bug fixes
since 9.2.8.

> Dump command : pg_dump.exe -U postgres -Fc -b test

> Platform : Windows Server 2008 R2

> Output of dump command is redirected to write end of named pipe.

I'm suspicious that that's exposing you to Windows' infamous text-mode
data mangling.  You might try using "-f namedpipe" instead of a shell
redirect.

            regards, tom lane