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 1lxpbh-0003xT-9k for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 11:39:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lxpbe-0005rO-H3 for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 11:39:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxpbe-0005rF-6Q for pgsql-admin@lists.postgresql.org; Mon, 28 Jun 2021 11:39:14 +0000 Received: from mx23.loc.gov ([140.147.239.49]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lxpbZ-0003li-Cn for pgsql-admin@lists.postgresql.org; Mon, 28 Jun 2021 11:39:13 +0000 Received: from pps.filterd (c2bappps03.loc.gov [127.0.0.1]) by c2bappps03.loc.gov (8.16.0.43/8.16.0.43) with SMTP id 15SBXwWc010247; Mon, 28 Jun 2021 07:39:05 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=loc.gov; h=from : to : subject : date : message-id : references : in-reply-to : content-type : mime-version; s=july2020; bh=IDNnIgXCTzM3y3J/AtCON3h3vsbe3EHwH+YWsy5d++I=; b=lg2T0yOrJbNcuYgrBX9JA5xBw8QMnH8OfvGQfXAMETBA5sJCjmarR8LELoUmM28jNoP4 UcQ6CgyZg2vnZS9Nwl4wIvw66t5tfgDwBcr/C/1JoMDgnPjDm6Ej5Ngq/t2xclIZ3kwd VG/NOk1XvOd0p2ClN9spCke8p6YzZU0yvDEp1/cIfId7L4+nMRSV8uSMPGebBu75rdqR 9rld6tge+k+weTslaF2GRYfcGT5/ReSXUWSXjZ6uuyalp4rDYsn6BnNVH4u6/Z+iBi+T oOhp2TaMQSBnsu1GCgkYrt1qN3MA0S+15X5Dew6fy0pW7Xpuv0tvHQfIBef5rltL728v wQ== Received: from mail2.loc.gov (acfxex01.loc.gov [140.147.237.145]) by c2bappps03.loc.gov with ESMTP id 39ex2pab6n-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT); Mon, 28 Jun 2021 07:39:05 -0400 Received: from ACFXEX04.LCDS.LOC.GOV (140.147.237.158) by ACFXEX01.LCDS.LOC.GOV (140.147.237.145) with Microsoft SMTP Server (TLS) id 15.0.1497.18; Mon, 28 Jun 2021 07:39:04 -0400 Received: from ACFXEX04.LCDS.LOC.GOV ([140.147.237.158]) by acfxex04.LCDS.LOC.GOV ([140.147.237.158]) with mapi id 15.00.1497.018; Mon, 28 Jun 2021 07:39:03 -0400 From: "Dai, Tino" To: Holger Jakobs , "pgsql-admin@lists.postgresql.org" Subject: Re: Comparing 2 data base or 2 tables Thread-Topic: Comparing 2 data base or 2 tables Thread-Index: AQHXbA6OkK2Zypjm5kG523TwTFkR76spi7MA///AYMg= Date: Mon, 28 Jun 2021 11:39:03 +0000 Message-ID: <1624880344134.31014@loc.gov> References: , In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [140.147.15.5] Content-Type: multipart/alternative; boundary="_000_162488034413431014locgov_" MIME-Version: 1.0 X-Proofpoint-ORIG-GUID: NxfbUjqVLgcSmobJZk6hgFEx78d6DBth X-Proofpoint-GUID: NxfbUjqVLgcSmobJZk6hgFEx78d6DBth X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.391,18.0.790 definitions=2021-06-28_09:2021-06-25,2021-06-28 signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 mlxscore=0 suspectscore=0 spamscore=0 priorityscore=1501 mlxlogscore=999 phishscore=0 lowpriorityscore=0 impostorscore=0 clxscore=1011 bulkscore=0 malwarescore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2104190000 definitions=main-2106280081 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_162488034413431014locgov_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ?If you are on a mac, you can use a tool called diff -T ________________________________ From: Holger Jakobs Sent: Monday, June 28, 2021 7:26 AM To: pgsql-admin@lists.postgresql.org Subject: Re: Comparing 2 data base or 2 tables Dump them using pg_dump and compare the files. Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 : Hi All, I am in trouble with a production database. So, I'm looking for a script or= tools comparing 2 postgre database schemas and extract data differences. I need a little help please. thanks lot. koff Berta -- Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short - --_000_162488034413431014locgov_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

​If you are on a mac, you can use a tool called diff


-T

From: Holger Jakobs <hol= ger@jakobs.com>
Sent: Monday, June 28, 2021 7:26 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: Comparing 2 data base or 2 tables
 
Dump them using pg_dump and compare the files.

Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 &l= t;koff10@hotmail.com>:

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

koff Berta

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