Horton

Re: Streaming a base backup from master

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: David Blewett <david@dawninglight.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Joshua Drake <jd@commandprompt.com>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, Stephen Frost <sfrost@snowman.net>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>, Magnus Hagander <magnus@hagander.net>, Dave Page <dpage@pgadmin.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-09-03T16:23:20Z
Lists: pgsql-hackers 
On 03/09/10 18:53, David Blewett wrote:
> On Fri, Sep 3, 2010 at 11:47 AM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> IOW, what I'd like to see is protocol extensions that allow an external
>> copy of rsync to be invoked; not build in rsync, or tar, or anything
>> else that we could get off-the-shelf.
>
> Personally, I would love to see protocol-level compression added.
> (Yes, going over a compressed SSH tunnel works well, but in general
> isn't user-friendly.)
>
> Josh: we talked on IRC awhile back and you mentioned that CMD had
> added this in Mammoth? Would you be interested in having someone get
> that integrated back into the community?

There's a recent thread on pgsql-general about just that:
http://archives.postgresql.org/pgsql-general/2010-08/msg00003.php

I agree with Tom's comments there, I'd like to have something to 
enable/disable SSL compression rather than implement our own. There was 
some discussion that it might not be available on JDBC SSL 
implementations, but if it's done in our protocol, you'll need changes 
to the client to make it work anyway.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com