Re: PostgreSQL Dump based backup using pipe

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL Dump based backup using pipe
Date: 2015-05-27 16:50:44
Message-ID: 2627.1432745444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

girish R G peetle <giri(dot)anamika0(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Charles Sprickman 2015-05-27 17:53:48 Re: autovacuum was not vacuuming
Previous Message girish R G peetle 2015-05-27 16:25:14 Re: PostgreSQL Dump based backup using pipe