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
FAQ