Re: tracking db changes / comparing databases

From: Michael Adler <adler(at)pobox(dot)com>
To: aplst(at)xs4all(dot)nl
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: tracking db changes / comparing databases
Date: 2004-08-18 14:46:41
Message-ID: 20040818144641.GA18663@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general


On Wed, Aug 18, 2004 at 04:09:33PM +0200, aplst(at)xs4all(dot)nl wrote:

> How do you share the data-definitions of your project(s) when they
> change (template1) ? Do you create all system-tables at pg_init
> runtime, and thus diff the C-source?

We track all DDL in CVS and manually create "patches" to upgrade all
installations of our product. It works for us.

-Mike

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-08-18 15:09:30 Re: [ADMIN] SRPM for 8.0.0 beta?
Previous Message Tom Lane 2004-08-18 14:33:45 Re: [HACKERS] SRPM for 8.0.0 beta?

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-18 15:05:58 Re: apple uses Postgres for RemoteDesktop 2
Previous Message Emi Lu 2004-08-18 14:45:01 How to setup default value "0000-00-00" for "date" type under PostgreSQL?