Thread: Schema comparisons

Hello!

I have two databases running on separate machines.  One is a production
server and the other is development.

I've been trying to be careful, but I've gotten out of synch with
whether or not I've applied the changes I've made to the development
system to the production system.  Is there a utility that will compare
the tables, functions, trigger, views, etc. between two systems and
flag the schema elements that aren't in synch between the two?

If not, and I need to write one, would such a system be of interest to
anyone else?

Thanks!
Mark

Mark Lubratt <mark.lubratt@indeq.com> writes:
> I've been trying to be careful, but I've gotten out of synch with
> whether or not I've applied the changes I've made to the development
> system to the production system.  Is there a utility that will compare
> the tables, functions, trigger, views, etc. between two systems and
> flag the schema elements that aren't in synch between the two?

Have you tried diffing pg_dump output?  It's not the greatest tool but
it's helpful.

            regards, tom lane