The PostgreSQL comparison and deployment tool you've been looking for.
Download an alpha build now and sign up to receive information about new releases.
Postgres Compare is a Postgres diff tool that automatically detects the changes made to your database and produces the SQL required to keep everything up to date. Increase visibility, reduce errors and save time with Postgres Compare.
Compare between live databases or snapshots from a point in time. Postgres Compare diffs the system catalogs and shows you where objects have been added, removed or changed.
Automatically write the SQL you need to deploy changes between environments. Postgres Compare helps ensure you include dependent objects and warns you of any destructive changes you might make.
Test your migration scripts on demand. One click will spin up a clone of the target database, run the migration script and report any issues encountered.
Create beautiful reports to illustrate the state of your environments. Store and share reports via your Postgres Compare account.
Postgres Compare goes where you go, so it's ready to work with your database environments straight away. It's cross platform too!
Log in to your Postgres Compare account to enable cloud features. Share reports, upload snapshots and test your deployment scripts on demand.
PostgreSQL's system catalogs store everything there is to know about the server and the structures contained in its databases.
Postgres Compare uses the system catalogs to determine the changes that have been made. The differences produce the CREATE, ALTER
and DELETE SQL that ensure the database is up to date.
Postgres Compare takes a snapshot of the server and stores it locally so you can easily keep track of changes or compare against old versions.
Connections, comparisons and deployment scripts too are stored for re-use and reporting purposes.
As an example imagine you have changed the datatype of a column in your test environment. Postgres Compare looks at the
pg_attribute system catalog and detects that the column has been changed compared to production.
You go ahead and generate a deployment script that saves you time and ensures you don't miss anything!
ALTER TABLE products ALTER COLUMN price TYPE numeric(10,2);
We don't do unsolicited emails, just useful updates and invitations to try Postgres Compare.