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

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

• Compare two PostgreSQL databases: With Redgate pgCompare, you can compare PostgreSQL schema changes from dev, to test, to production and explore what’s changed in each database object, down to individual lines of code. When you’re ready to deploy the changes, 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.