Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xyi2I-0003jj-Sr for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2014 14:14:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xyi2I-0001z4-Ce for pgsql-admin@arkaria.postgresql.org; Wed, 10 Dec 2014 14:14:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xyi2G-0001xY-PL for pgsql-admin@postgresql.org; Wed, 10 Dec 2014 14:14:36 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xyi2D-00036C-7G for pgsql-admin@postgresql.org; Wed, 10 Dec 2014 14:14:35 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 5DF555FA1F; Wed, 10 Dec 2014 09:14:31 -0500 (EST) Date: Wed, 10 Dec 2014 09:14:31 -0500 From: Stephen Frost To: "Ferrell, Denise CTR NSWCDD, Z11" Cc: "pgsql-admin@postgresql.org" Subject: Re: Comparing two databases for differences Message-ID: <20141210141431.GR25679@tamriel.snowman.net> References: <2BC18916DE4BF141AC1EFC55CE2CAE7D5C096E@NAEANRFKXM01V.nadsusea.nads.navy.mil> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="UNrMg7q4I5bA1PGX" Content-Disposition: inline In-Reply-To: <2BC18916DE4BF141AC1EFC55CE2CAE7D5C096E@NAEANRFKXM01V.nadsusea.nads.navy.mil> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-40-generic (x86_64) X-Uptime: 09:13:16 up 11 days, 18:01, 5 users, load average: 0.07, 0.13, 0.13 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) 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 --UNrMg7q4I5bA1PGX Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Denise, * Ferrell, Denise CTR NSWCDD, Z11 (denise.ferrell.ctr@navy.mil) wrote: > Does anyone know of an easy way to compare 2 database instances? Especially the stored procedures and tables from the two databases. The Nagios module check_postgres.pl has the ability to compare database instances. Thanks! Stephen --UNrMg7q4I5bA1PGX Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJUiFVGAAoJEO1sijiDR2RVA1YP/2S5/BP/E6okuqekf5Sf/5U5 cVXyu3w5NL04Nkfcv3bduocBNKehIRUFXuj27qsNtfCmomwTc/I0QFojKKrJ+ikE 60GjHIfnnwT4jIN0uv5MnxrcLy4UGVCWlNHmU7WM1NJyZuSPH6j1L5GOLcZtNx2j dkE4X5AWMxIWxv+mq+9Uf71W0b/YOUxM/KVEsMFdCduWhiWLFIuRRsSYklulz75y gilco6HH4mFffjvn7lRt6GpFUjG7PhfBgohDTwG8L3lNxQtxS2NJJcHfsBGwFUl0 /Ltkrfd5gzaQMSdQsJgMMYA8bqeJI7jVM5O1Yd/GkldiAqLmYcWXUEkTwf2TPDb7 UPT8QbuimKJKqcMDc73a8QWXvjmXtURvXO1s38NznzYbAXdZNsdpyrUsLp4pUkQ0 TivZZ5YHefCsHItBoqiqpDUywZAJnqlg7Mq0fadk35aHuq1XnnzilZNxb3MUcp9H 9HSy8At/4bKUKhb68d8RO76zEoDAdgAFZ88zXyv6yGPSlDjZNZKZD3JeiA11+YRa o1989KqzSYjvrXaABf0jqKr95PUAacUARhAstqb/IKXrFhCb84bzoCiXGDQ5wBNP WCBOYBMyl/X2VIrvbH0/DgHYke88aWRoU0fZFKlct91k3ZWjFzUx7j/mTsLb/ySa kZ7U6CKZf7Gpv9tXk37I =1QV8 -----END PGP SIGNATURE----- --UNrMg7q4I5bA1PGX--