From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"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>, "Stephen Frost" <sfrost(at)snowman(dot)net>
Subject:
Re: Streaming a base backup from master
Date:
2010-09-03 16:11:34
Message-ID:
4C80D7E6020000250003519B@gw.wicourts.gov (view raw or flat )
Thread:
2010-09-03 11:19:20 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 11:25:35 from Thom Brown <thom(at)linux(dot)com>
2010-09-03 11:30:02 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-09-03 11:32:51 from Thom Brown <thom(at)linux(dot)com>
2010-09-03 11:43:49 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 11:28:12 from Dave Page <dpage(at)pgadmin(dot)org>
2010-09-03 11:48:55 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 11:50:09 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-09-03 13:24:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-03 13:26:41 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-09-03 13:26:49 from Dave Page <dpage(at)pgadmin(dot)org>
2010-09-03 13:29:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-03 13:32:42 from Dave Page <dpage(at)pgadmin(dot)org>
2010-09-03 13:43:13 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-03 13:56:12 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-03 15:02:06 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-03 15:20:08 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-03 15:32:20 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-03 15:47:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-03 15:53:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-03 15:53:09 from David Blewett <david(at)dawninglight(dot)net>
2010-09-03 16:23:20 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 20:56:39 from David Blewett <david(at)dawninglight(dot)net>
2010-09-03 16:09:04 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-09-03 16:22:06 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 16:11:34 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-03 15:41:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-03 19:30:42 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2010-09-04 13:42:40 from Greg Stark <gsstark(at)mit(dot)edu>
2010-09-04 13:46:49 from Thom Brown <thom(at)linux(dot)com>
2010-09-05 02:58:25 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-05 15:51:38 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2010-09-06 14:07:59 from Greg Stark <gsstark(at)mit(dot)edu>
2010-09-06 22:09:50 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-08 01:28:39 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-09-03 11:28:51 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-09-03 12:16:25 from Greg Stark <gsstark(at)mit(dot)edu>
2010-09-03 12:28:58 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 15:01:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-03 15:22:35 from Thom Brown <thom(at)linux(dot)com>
2010-09-03 15:38:35 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Lists:
pgsql-hackers
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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.
The complexities of dealing with properly invoking rsync externally
could well require more code and be considerably more fragile than
passing the data through the existing SR connection; particularly
since to get the full benefits of rsync you need to be dealing with
a daemon which has the appropriate modules configured -- the
location of which you wouldn't easily know.
If we were talking about re-implementing rsync, or doing more than a
rough approximation, kinda, of 5% of what rsync does, I'd be with
you.
-Kevin
In response to
pgsql-hackers by date
Next :From: Heikki LinnakangasDate: 2010-09-03 16:22:06Subject : Re: Streaming a base backup from masterPrevious :From : Tom LaneDate : 2010-09-03 16:10:42Subject : Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)
