Schema comparisons
Schema comparisons
От:
Mark Lubratt <mark.lubratt@indeq.com>
Дата:
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
Re: Schema comparisons
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Mark Lubratt 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