Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxpP8-0003Rp-31 for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 11:26:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lxpP7-0006tq-2l for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 11:26:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxpP6-0006ti-Qi for pgsql-admin@lists.postgresql.org; Mon, 28 Jun 2021 11:26:16 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxpP4-0001ud-AD for pgsql-admin@lists.postgresql.org; Mon, 28 Jun 2021 11:26:15 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 157DC380399; Mon, 28 Jun 2021 13:26:12 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id rtX81gms8q9O; Mon, 28 Jun 2021 13:26:12 +0200 (CEST) Received: from dyn113.linuxhotel.de (185-232-103-115.xdsl.philuweb.net [185.232.103.115]) by rs.plausibolo.de (Postfix) with ESMTPSA id B7F1C3802AD; Mon, 28 Jun 2021 13:26:11 +0200 (CEST) Date: Mon, 28 Jun 2021 13:26:04 +0200 User-Agent: K-9 Mail for Android In-Reply-To: References: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----NCZA9YHWX31C1OGT14KCECYPM6QGI7" Content-Transfer-Encoding: 7bit Subject: Re: Comparing 2 data base or 2 tables To: pgsql-admin@lists.postgresql.org From: Holger Jakobs Message-ID: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------NCZA9YHWX31C1OGT14KCECYPM6QGI7 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Dump them using pg_dump and compare the files=2E Am 28=2E Juni 2021 13:12:26 MESZ schrieb koff10 : > >Hi All, >I am in trouble with a production database=2ESo, I'm looking for a script > >or tools comparing 2 postgre database schemas >and extract data differences=2E >I need a little help please=2E >thanks lot=2E > >koff Berta --=20 Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short - ------NCZA9YHWX31C1OGT14KCECYPM6QGI7 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Dump them using pg_dump and compare the files=2E

Am 28=2E Juni 2021 13:12:26 MESZ schrieb koff10 <koff10= @hotmail=2Ecom>:

Hi All,
I am in trouble with a production database=2E So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences=2E
I need a little help please=2E
thanks lot=2E

koff Berta
=20

--
Holger Jakobs, Bergisch Gladbach
+49 178 = 9759012
- sent from mobile, therefore short -
------NCZA9YHWX31C1OGT14KCECYPM6QGI7--