Re: Backup using GiT?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup using GiT?
Date: 2008-06-13 17:36:12
Message-ID: 20080613173612.GA5070@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

James B. Byrne wrote:

> GiT works by compressing deltas of the contents of successive versions of file
> systems under repository control. It treats binary objects as just another
> object under control. The question is, are successive (compressed) dumps of
> an altered database sufficiently similar to make the deltas small enough to
> warrant this approach?

Hmm, perhaps a not completely insane thing to do would be to use another
pg_dump "format" (i.e. a new -F option) which installs stuff on a GIT
repo.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message D Galen 2008-06-13 18:18:46 Lost psql.exe on 8.3.3 upgrade
Previous Message James B. Byrne 2008-06-13 17:33:23 Backup using GiT?