Re: Backup using GiT?

Tom Lane wrote:
> "James B. Byrne" <byrnejb(at)harte-lyne(dot)ca> writes:

> > 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?
>
> No. If you compress it, you can be pretty certain that the output will
> be different from the first point of difference to the end of the file.
> You'd have to work on uncompressed output, which might cost more than
> you'd end up saving ...

The other problem is that since the tables are not dumped in any
consistent order, it's pretty unlikely that you'd get any similarity
between two dumps of the same table. To get any benefit, you'd need to
get pg_dump to dump sorted tuples.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.