PostgreSQL compare databases tool or generating migration script util

Question

In our development we use two servers with PostgreSQL 8.4 - development and production. So, after changes were made on development server we would like to automatically generate SQL migration scripts. I found that EMS DB Comparer for PostgreSQL can do it, but it is only for Windows (our development team use Ubuntu for developing). Do you now alternative tools to do this?

Answer 1

Check out the wiki: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

Answer 2

We use Aqua Data Studio. It has a nice schema compare tool and works with a myriad of different RDBMS's. Its also Java based so it runs on almost any platform. Not exactly cheap, but well worth it IMO. And if you want free, there are several tools on pgfoundry.

Answer 3

You can have a look at Another PostgreSQL Diff Tool. You pass it schema dump files from your production server and development server and it will generate DDL statements that will convert your production database to the same state as your development database. The application is free, and coded in Java so you can run it everywhere where you can run Java. You can find more detail about the application on the website.