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