Schema comparisons

[Mark Lubratt]

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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

Post by Mark Lubratt
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster