Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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.