From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc:
Greg Stark <gsstark(at)mit(dot)edu>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>,
Magnus Hagander <magnus(at)hagander(dot)net>
Subject:
Re: Streaming a base backup from master
Date:
2010-09-03 15:01:36
Message-ID:
22881.1283526096@sss.pgh.pa.us (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
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> On 03/09/10 15:16, Greg Stark wrote:
>> On Fri, Sep 3, 2010 at 12:19 PM, Heikki Linnakangas
>> <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>>> * We need a smarter way to do pg_start/stop_backup() with this. At the
>>> moment, you can only have one backup running at a time, but we shouldn't
>>> have that limitation with this built-in mechanism.
>>
>> Well there's no particular reason we couldn't support having multiple
>> pg_start_backup() pending either. It's just not usually something
>> people have need so far.
> The backup label file makes that hard. There can be only one at a time.
I don't actually see a use-case for streaming multiple concurrent
backups. How many people are going to be able to afford that kind of
load on the master's I/O bandwidth?
Certainly for version 1, it would be sufficient to throw an error if
someone tries to start a backup while another one is in progress.
*Maybe*, down the road, we'd want to relax it.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Kevin GrittnerDate: 2010-09-03 15:02:06Subject : Re: Streaming a base backup from masterPrevious :From : Tom LaneDate : 2010-09-03 14:51:37Subject : Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)
