Migrations for PostgreSQL

Red-Gate has very interesting in beta software (Sql Source Control) that is 开发者_如何学Cinstalling inside SSMS and can save schema iterations through commit button. I need the same feature for postgresql, the only way i found similar to this - is log_statement = ddl, but log need be transformed and saved properly to file and than commited. What is your opinion about postgresql iteration tools?

Not exactly like Red Gate's tool, but check out http://www.liquibase.org/. Might pique your interest considering your topic.

Maybe Post Facto is similar to what you want.

Another PostgreSQL Diff Tool (apgdiff) sounds like it works a lot like Red Gate's SQL Source Control and SQL Compare:

Another PostgreSQL Diff Tool (also known as apgdiff) is free PostgreSQL diff tool that is useful for comparison/diffing of database schemas. The tool compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one or to see in what exactly both databases differ.