Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I've used red-gate's sql compare with sqlserver for checking table/index/proc differences, is there anything similar for postgres?

What I want to do is figure out between development, QA, and production databases if there are any indexes or other schema changes in case something was missed.

share|improve this question

2 Answers 2

up vote 0 down vote accepted

Here is one implementation that will do what you are looking for:

share|improve this answer

Check_postgres from bucardo has a schema diff option. This a perl-based script I have used and found handy.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.