Re: Database version control

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Alex du Plessis <alexdup01(at)telkomsa(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Database version control
Date: 2007-11-20 07:02:07
Message-ID: 4742866F.3020604@Sheeky.Biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Alex du Plessis wrote:
> Hello list,
>
> Is there any way to do version control on a database from one
> application version to another?
>
> IE how do I do an upgrade (or even know that I have to do an upgrade) of
> the database when I have a new application release.
>

Provided you have a copy of the db structure that you released initially
you will want to start with a current dump (no data)

You can diff these two files to find any differences.

You may also want to have a look at pgdiff and apgdiff - both are
located at sourceforge.

--

Shane Ambler
pgSQL(at)Sheeky(dot)Biz

Get Sheeky @ http://Sheeky.Biz

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Emil Oppeln-Bronikowski 2007-11-20 07:08:27 Re: Database version control
Previous Message Alex du Plessis 2007-11-19 20:46:28 Database version control