Re: Tracking structural changes from psql - Mailing list pgsql-general

From Daniel Vérité
Subject Re: Tracking structural changes from psql
Date
Msg-id m3y8o88qe8.fsf@club-internet.fr
Whole thread Raw
In response to Tracking structural changes from psql  (Mike McGavin <jester@NOSPAM.mcsnospam.vuw.acNOSPAM.nz>)
List pgsql-general
Mike McGavin <jester@NOSPAM.mcsnospam.vuw.acNOSPAM.nz> writes:

> It also occurs to me that an even more useful utility might be one
> that stores the structural state of the database at a particular time
> (such as when I last updated the production server), and then generate
> a diff of SQL statements to update it to the current structural state.
> I don't suppose this already exists anywhere, does it?

You might want to try:

http://zongle.sourceforge.net/
http://pgdiff.sourceforge.net/
http://gborg.postgresql.org/project/pgdiff/projdisplay.php

--
 Daniel Vérité - daniel at manitou dash mail dot org

pgsql-general by date:

Previous
From: CS Wagner
Date:
Subject: Load Balancing and Backup
Next
From: david_e_roche@yahoo.com (David Roche)
Date:
Subject: How to abort psql when backtick (shell) commands return non-zero?