Re: Streaming base backups

From: Hannu Krosing <hannu(at)2ndquadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming base backups
Date: 2011-01-09 08:55:09
Message-ID: 4D2977ED.1050203@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 7.1.2011 15:45, Magnus Hagander wrote:
> On Fri, Jan 7, 2011 at 02:15, Simon Riggs<simon(at)2ndquadrant(dot)com> wrote:
>
>> One very useful feature will be some way of confirming the number and
>> size of files to transfer, so that the base backup client can find out
>> the progress.
> The patch already does this. Or rather, as it's coded it does this
> once per tablespace.
>
> It'll give you an approximation only of course, that can change,
In this case you actually could send exact numbers, as you need to only
transfer the files
up to the size they were when starting the base backup. The rest will
be taken care of by
WAL replay

> but
> it should be enough for the purposes of a progress indication.
>
>
>> It would also be good to avoid writing a backup_label file at all on the
>> master, so there was no reason why multiple concurrent backups could not
>> be taken. The current coding allows for the idea that the start and stop
>> might be in different sessions, whereas here we know we are in one
>> session.
> Yeah, I have that on the todo list suggested by Heikki. I consider it
> a later phase though.
>
>

--
--------------------------------------------
Hannu Krosing
Senior Consultant,
Infinite Scalability& Performance
http://www.2ndQuadrant.com/books/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2011-01-09 09:03:10 Re: WIP: Range Types
Previous Message Tom Lane 2011-01-09 05:41:13 Re: Fixing GIN for empty/null/full-scan cases