PostgreSQL pg_dump output reading from named pipe on Windows is giving duplicate dump content

From: girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL pg_dump output reading from named pipe on Windows is giving duplicate dump content
Date: 2015-05-18 09:17:02
Message-ID: CAKKd066nLt1-UetwqQox6oxKYKhYXGFEFBZeqbicMxqGR6JiDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL Version - 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. From read
end of the pipe data is read. From 'strings dump-file' output I could see
that all the SQL statements in the dump file are repeated.
Also I see below errors in dump output.

*pg_dump: [custom archiver] WARNING: ftell mismatch with expected position
-- ftell used*

This doesn't happen if the pg_dump (on Windows) is redirected into a file
or '-f outputFile' option is used.

Please find attached dump file ( test-WithPipe.dump ) and strings output of
dump file ( test-withPipe.dump.strings)

Why do we see this behavior with pg_dump command using PIPEs ?

*test-withPipe.dump.strings*

CREATE DATABASE test WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE
= 'English_India.1252' LC_CTYPE = 'English_India.1252';
DROP DATABASE test;
postgres
false
-----------------
-------------------------
-----------------------------
CREATE DATABASE test WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE
= 'English_India.1252' LC_CTYPE = 'English_India.1252';
DROP DATABASE test;
postgres
false
2615
------------
--------------------------------------

Thanks
Girish

Attachment Content-Type Size
test-withPipe.dump application/octet-stream 8.6 KB
test-withPipe.dump.strings application/octet-stream 2.9 KB

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas SIMON 2015-05-18 13:05:49 Performances issues with SSD volume ?
Previous Message Bruce Momjian 2015-05-16 04:40:51 Re: Missing timeline history file after execution of pg_upgrade