| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Streaming base backups |
| Date: | 2011-01-06 09:09:42 |
| Message-ID: | 4D2586D6.6070905@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 06.01.2011 00:27, Dimitri Fontaine wrote:
> Magnus Hagander<magnus(at)hagander(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian Pflug | 2011-01-06 11:27:21 | Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE |
| Previous Message | Simon Riggs | 2011-01-06 08:19:55 | Re: ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED |