Skip site navigation (1) Skip section navigation (2)

Schema comparisons

From: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Schema comparisons
Date: 2004-02-28 03:32:43
Message-ID: C4BBB0BE-699E-11D8-ACD3-000A9579AF50@indeq.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
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


Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-02-28 03:49:39
Subject: Re: Tablespaces
Previous:From: Andrew DunstanDate: 2004-02-28 00:47:30
Subject: Re: [HACKERS] Collaboration Tool Proposal

pgsql-admin by date

Next:From: Tom LaneDate: 2004-02-28 04:28:25
Subject: Re: Schema comparisons
Previous:From: Anjan DaveDate: 2004-02-27 22:28:52
Subject: Re: pg_restore data block error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group