tool for comparing databases (?)
От | Michael Adler |
---|---|
Тема | tool for comparing databases (?) |
Дата | |
Msg-id | Pine.NEB.4.44.0205141444250.18781-100000@reva.sixgirls.org обсуждение исходный текст |
Ответ на | Re: Use of OIDS as primary keys (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Does there exist a method or tool to compare two PostgreSQL databases? Say you have an application based on PostgreSQL and it is deployed to dozens or hundreds of disparate systems. Different versions (v1.2, v1.3) of the application require somewhat different database schemas (e.g. v1.3 has an extra column on one table). Over a long period of time and many upgrades, it would be worthwhile to validate that your database fits the expected schema. How could one acheive this? This seems like a useful general purpose tool, so perhaps this question has already been addressed. If one could "pg_dump" the system catalogs, they would have database schema snapshots. Next, they would need a tool to compare two snapshots (in whole or in part) and determine the relationship (A matches B exactly, A contains all of B plus + some extra X, or A contains all of B except for missing Y). Comments? Suggestions? Interest? Mike Adler
В списке pgsql-general по дате отправления: