PITR will allow you to recover a database to a specific point in time,
if that's what you're looking for. Otherwise you're probably stuck
rolling your own, but fortunately rules make that pretty easy to do.
On Thu, Dec 15, 2005 at 04:05:33PM -0600, Amit Kulkarni wrote:
> Hi all,
>
> Quite new to Postgres and initially driven here due to PostGIS. One
> thing I was looking at was the ability to roll back to a certain time,
> multiple editing, and QC. Basically a version control for databases. I
> went through the TODO list and I don't see this listed there, unless it
> is in the context of Point-in-time-recovery.
>
> I asked my brother for help, and he sent me a link to Martin Fowler's
> temporal site http://www.martinfowler.com/ap2/timeNarrative.html
>
> (We discussed maintaining a master table, and recording all SQL DMLs,
> basically a-rolling-your-own implementation.)
>
> Fowler refers to Snodgrass 99, and I am waiting to get hold of
> Snodgrass. Then today I came to know of Oracle Workspace Manager.
>
> This product is used by Intergraph in their Geomedia Transaction
> Manager, which relies totally on OWM to manage conflicts of multiple
> edits in the same geographic area. I suspect that some other Geographic
> vendors are also using OWM (Ionic RedSpider) though I am not sure. I
> didn't post to the PostGIS list as I am thinking the question properly
> belongs here.
>
> Is anything like this in the works either here or in Bizgres?
>
> Thanks in advance!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461