Skip site navigation (1) Skip section navigation (2)

Re: Streaming a base backup from master

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, 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 13:24:19
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
On Fri, Sep 3, 2010 at 7:28 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> On Fri, Sep 3, 2010 at 12:19 PM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>> Here's a WIP patch. It adds a new "TAKE_BACKUP" command to the replication
>> command set. Upon receiving that command, the master starts a COPY, and
>> streams a tarred copy of the data directory to the client. The patch
>> includes a simple command-line tool, pg_streambackup, to connect to a server
>> and request a backup that you can then redirect to a .tar file or pipe to
>> "tar x".
> Cool. Can you add a TODO to build in code to un-tar the archive? tar
> is not usually found on Windows systems, and as we already have tar
> extraction code in pg_restore it could presumably be added relatively
> painlessly.

It seems like the elephant in the room here is updating an existing
backup without recopying the entire data directory.  Perhaps that's
phase two, but worth keeping in mind...

Robert Haas
The Enterprise Postgres Company

In response to


pgsql-hackers by date

Next:From: Magnus HaganderDate: 2010-09-03 13:26:41
Subject: Re: Streaming a base backup from master
Previous:From: Hans-Jürgen SchönigDate: 2010-09-03 13:16:58
Subject: Re: Path question

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group