Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XynMC-0007iF-Me for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2014 19:55:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XynMC-0006bP-5t for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2014 19:55:32 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XynMB-0006ZH-9h for pgsql-admin@postgresql.org; Wed, 10 Dec 2014 19:55:31 +0000 Received: from zql.com ([206.222.31.58]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XynM7-0008QR-Oj for pgsql-admin@postgresql.org; Wed, 10 Dec 2014 19:55:29 +0000 Received: from localhost ([127.0.0.1]) by zql.com with smtp (Exim 4.68) (envelope-from ) id 1XynM5-0000CN-N1; Wed, 10 Dec 2014 14:55:25 -0500 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: Comparing two databases for differences X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <20141210141431.GR25679@tamriel.snowman.net> Date: Wed, 10 Dec 2014 19:55:25 -0000 X-Mailer: JoyMail 3.0.1 Message-ID: <02f85237e610deb257f8de8004168001@biglumber.com> X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org -----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