Re: Version Control Software for Database Objects

From: Jeff Davis <jdavis-pgsql(at)empires(dot)org>
To: Mark Dexter <MDEXTER(at)dexterchaney(dot)com>
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Version Control Software for Database Objects
Date: 2005-01-14 01:45:05
Message-ID: 1105667105.2886.419.camel@jeff
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2005-01-13 at 15:18 -0800, Mark Dexter wrote:
> We maintain multiple versions of our application's database and we are
> looking for version control software to help us automate this.
> Specifically, we would like to have a program that automatically
> tracks all changes to the database (tables, views, functions, etc.)
> and assists with updating customers' databases from one version to the
> next.
>
> Does anyone know of such a program that works with PostgreSQL? Thanks
> for your help.

Perhaps Point in Time Recovery can help you:

<http://developer.postgresql.org/docs/postgres/backup-online.html>

It's a new feature in 8.0.

You might also want to look into some of the available replication
solutions.

Regards,
Jeff Davis

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Allen 2005-01-14 02:06:58 Re: Version Control Software for Database Objects
Previous Message Tom Lane 2005-01-14 01:19:28 Re: index on user defined type