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

Re: Postgres table contents versioning

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres table contents versioning
Date: 2010-06-30 14:06:31
Message-ID: m3lj9wd388.fsf@passepartout.tim-landscheidt.de (view raw or flat)
Thread:
Lists: pgsql-general
John Gage <jsmgage(at)numericable(dot)fr> wrote:

> Is there an equivalent of svn/git etc. for the data in a
> database's tables?

> Can I set something up so that I can see what was in the
> table two days/months etc. ago?

> I realize that in the case of rapidly changing hundred
> million row tables this presents an impossible problem.

> The best kludge I can think of is copying the tables to a
> directory and git-ing the directory.

If you're looking at this from a disaster recovery point of
view, you should read up on PostgreSQL's PITR capabilities.
If you need the information in your application, you should
google for "temporal databases" on how to amend your table
structures.

Tim


In response to

pgsql-general by date

Next:From: sam mulubeDate: 2010-06-30 14:20:35
Subject: Re: Postgresql partitioning - single hot table or distributed
Previous:From: A. KretschmerDate: 2010-06-30 13:54:13
Subject: Re: Postgres table contents versioning

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