On Fri, Sep 3, 2010 at 7:28 AM, Dave Page <dp...@pgadmin.org> wrote: > On Fri, Sep 3, 2010 at 12:19 PM, Heikki Linnakangas > <heikki.linnakan...@enterprisedb.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 EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
