From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-admin@postgresql.org
Subject: Re: Comparing two databases for differences
Date: Wed, 10 Dec 2014 19:55:25 -0000
Message-ID: <02f85237e610deb257f8de8004168001@biglumber.com> (raw)
In-Reply-To: <20141210141431.GR25679@tamriel.snowman.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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-----
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@turnstep.com
Subject: Re: Comparing two databases for differences
In-Reply-To: <02f85237e610deb257f8de8004168001@biglumber.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox