Re: Comparing two databases for differences - Mailing list pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


>> Does anyone know of an easy way to compare 2 database instances?
> The Nagios module check_postgres.pl has the ability to compare database instances.

To expand on how easy this is:

wget -q http://bucardo.org/downloads/check_postgres.pl

perl check_postgres.pl --action=same_schema --db=mydb1 --db=mydb2

More details here:

http://bucardo.org/check_postgres/check_postgres.pl.html#same_schema

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201412101455
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlSIpRkACgkQvJuQZxSWSsgJXwCeL7pqzLsez4FkUpq0ZopW4HyD
o40AnjY3wa+/LpbQRIKkVgsnMbdYdPuD
=aJk3
-----END PGP SIGNATURE-----