| From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: recommended schema diff tools? |
| Date: | 2012-04-17 16:02:34 |
| Message-ID: | 530db99200af1652d214f9c4e450b219@biglumber.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> can anyone recommend an open source tool for diffing schemas?
You might want to check out the "same_schema" action of check_postgres.pl:
http://bucardo.org/check_postgres/check_postgres.pl.html#same_schema
http://bucardo.org/wiki/Check_postgres
It allows you to compare the schemas of any number of databases to
each other, and also compare a schema to an earlier version of itself,
which can be used for things such as mailing a list of all schema
changes in the last 24 hours, for example.
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201204171202
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAk+NlAUACgkQvJuQZxSWSsjhrwCg7VgFxG8xh6+pfup4QMSxdtKz
tJcAoIkmtNRKOtYue5jRy9+FpTy6707u
=wwqY
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nils Gösche | 2012-04-17 16:58:03 | Feature Proposal: Constant Values in Columns or Foreign Keys |
| Previous Message | Videanu Adrian | 2012-04-17 14:10:53 | pgpool2 master fail problem |