From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Comparing two databases for differences |
Date: | 2014-12-10 19:55:25 |
Message-ID: | 02f85237e610deb257f8de8004168001@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)turnstep(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Strahinja Kustudić | 2014-12-10 21:11:56 | Re: Comparing two databases for differences |
Previous Message | jaime soler | 2014-12-10 19:53:29 | Re: Comparing two databases for differences |