Re: Streaming a base backup from master

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: David Blewett <david(at)dawninglight(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joshua Drake <jd(at)commandprompt(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Stephen Frost <sfrost(at)snowman(dot)net>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Dave Page <dpage(at)pgadmin(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming a base backup from master
Date: 2010-09-03 16:23:20
Message-ID: 4C8120F8.20906@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 03/09/10 18:53, David Blewett wrote:
> On Fri, Sep 3, 2010 at 11:47 AM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2010-09-03 16:24:06 Re: Windows Tools
Previous Message Heikki Linnakangas 2010-09-03 16:22:06 Re: Streaming a base backup from master