On 06.01.2011 00:27, Dimitri Fontaine wrote:
> Magnus Hagander<magnus@hagander.net> writes:
>>> What about pg_streamrecv | gzip> …, which has the big advantage of
>>
>> That's part of what I meant with "easier and more useful".
>
> Well…
One thing to keep in mind is that if you do compression in libpq for the
transfer, and gzip the tar file in the client, that's quite inefficient.
You compress the data once in the server, decompress in the client, then
compress it again in the client. If you're going to write the backup to
a compressed file, and you want to transfer it compressed to save
bandwidth, you want to gzip it in the server to begin with.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com