Introducing Redgate pgCompare — the fastest way to compare and deploy PostgreSQL schemas.

Whether you need to deploy changes or explore the differences between two PostgreSQL databases, Redgate pgCompare helps you do the job quickly, simply, and with zero errors.

• Compare PostgreSQL schema changes from dev, to test, to production: Compare PostgreSQL database schemas, large or small.  You can explore what’s changed in each database object, down to individual lines of code. When you’re ready to deploy, you can create an error-free deployment script in minutes.
• Find and fix problems in production: To fix errors in your production database, compare it to another database. You can deploy single objects to fix the issue fast.
• Deploy with zero errors: Redgate pgCompare scripts dependencies in your database in the right order, to make sure deployment is successful. You’ll get notifications about any issues, such as data loss, before you deploy.