From: Dave Page <dpage@vale-housing.co.uk>
To: Magnus Hagander <mha@sollentuna.net>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Possible TODO item: copy to/from pipe
Date: Wed, 31 May 2006 20:55:17 +0100
Message-ID: <C0A3B335.D1F4%dpage@vale-housing.co.uk> (raw)
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA3546D@algol.sollentuna.se>
On 31/5/06 18:28, "Magnus Hagander" <mha@sollentuna.net> wrote:
>>>>> Won't help too much, until gzip's output is piped back too, so a
>>>>> replacement for COPY .. TO STDOUT COMPRESSED would be
>> COPY ... TO '|
>>>>> /bin/gzip |' STDOUT, to enable clients to
>>>>
>>>> receive the
>>>>
>>>>> reduced stuff.
>>>>
>>>> Forgot to mention:
>>>> COPY COMPRESSED was also meant to introduce a portable
>> format that's
>>>> efficient for both text and binary data. Relying on some external
>>>> XYZzip version seems not too portable to me.
>>>
>>>
>>> It does have that advantage. Gzip and others are not particularly
>>> Windows friendly for example.
>>
>> ... as most windows programs are pipe agnostic.
>
> For the record, gzip on win32 works perfectly fine both as a separate
> program and running in a pipe. No problem at all. The only issue is that
> it's not available by default. (And possible issues with programs
> launching it that don't know how to deal with windows style directory
> naming)
Exactly my point; how many production Windows servers do you have with gzip
anywhere near them? Andreas' point about pipes is also valid though - it's
simply not the norm on Windows as I found when we were porting Slony
(more.exe barfs at >8MB being pipe in).
Regards, Dave.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: dpage@vale-housing.co.uk, mha@sollentuna.net, pgadmin@pse-consulting.de, tgl@sss.pgh.pa.us
Subject: Re: Possible TODO item: copy to/from pipe
In-Reply-To: <C0A3B335.D1F4%dpage@vale-housing.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox