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 1lxpsf-0004Pr-BG for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 11:56:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lxpsd-0001Ey-UX for pgsql-admin@arkaria.postgresql.org; Mon, 28 Jun 2021 11:56:47 +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 1lxpsd-0001Eh-K5 for pgsql-admin@lists.postgresql.org; Mon, 28 Jun 2021 11:56:47 +0000 Received: from mail-ot1-x32a.google.com ([2607:f8b0:4864:20::32a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lxpsb-00046Q-DO for pgsql-admin@lists.postgresql.org; Mon, 28 Jun 2021 11:56:47 +0000 Received: by mail-ot1-x32a.google.com with SMTP id m6-20020a9d1d060000b029044e2d8e855eso16515026otm.8 for ; Mon, 28 Jun 2021 04:56:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=/8HQqZcbhYUrg5CQy0LY4GPanpg0yDsptzXQ9Dnx6Ec=; b=SztQzMxsL/oKXUA29RYI1yBlAiLu2pTUh6KuQ9pJw/yS6zyYauv2MUQx5i6+tHZnpH c7SGy9RaelMVJlh3htkCGk6i2UKnr2TOTVYIqK77Zqcn8nfUh6WsgUro43VwPCF6mtFt K/+AoVQsJmHj8C34uCECHH6cmevUXsmw4v5Adue/fIIFw5+ocG5jAUOhQVbCYG/YT8m6 pOc+X0q0yU6w0XcMU1z8Egwlx9czEwKu5xR66ZKolxq4qHHDhLtwmNMYTX7P5YPAT1M0 oH+KrDAFlirI97seEZLNt+qnUVzVjFaJGrQCKsiEcQQ3jJr8Tf/AXKrWAv5IiJo2Ules AtcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=/8HQqZcbhYUrg5CQy0LY4GPanpg0yDsptzXQ9Dnx6Ec=; b=i8HDl6f7qzfMX2sAY3+NpUIJ970i6YtF60XuUpllhJJRuF0KyQTFE8Y/olYzxHRWT8 84UGpSLh+l29UUolZY3wvKnEMwIoJl9nIDdHJhWEJu9yOE5wIDy4oWwn7NJFw2EXTJRm AKZImJj+I30vaNi8WYIvADkusDv+0iMFlCcHAzO7S2N9AifNqYuusceJDqHrc4wJTI6J TrBUIA0wz+zXbhrR0PmaDbd3DulHNd67LwCflrzXoXDnylpGwxkeLvZnYPYFhZlgAsTa yKgL5yKDe5nkY5Ww0L5/5bCravp3XGCRNefdrh8eQBA+TBG54SBABWlEGkj6X9isa1Cq WFZg== X-Gm-Message-State: AOAM533Tp1zyYWGHmZu580tIY3Xe3haGdLTS8jf0eD8Pk14qvJ+c5Ilr /2igTWo4l0ZVOLBjVDXqXK/AzUoQJ5ukYg== X-Google-Smtp-Source: ABdhPJxGAkjtLQRTVF34ExBTVVPH0ZJTqykbVdszmKgPjnLIATPBskmRYoijJHxPWLg6G0sRBsIDlg== X-Received: by 2002:a9d:469e:: with SMTP id z30mr6082875ote.53.1624881402234; Mon, 28 Jun 2021 04:56:42 -0700 (PDT) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id o71sm2517121ooo.7.2021.06.28.04.56.41 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 28 Jun 2021 04:56:41 -0700 (PDT) Subject: Re: Comparing 2 data base or 2 tables To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <37bee87a-dc48-64e3-4bdf-6afa1dcf566c@gmail.com> Date: Mon, 28 Jun 2021 06:56:40 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------1B9FC926105D4976BCAC8E4E" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1B9FC926105D4976BCAC8E4E Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Meld is an excellnet file compare program. On 6/28/21 6:41 AM, koff10 wrote: > Thanks lot, > I did not think about it > koff > > Le 28/06/2021 à 13:26, Holger Jakobs a écrit : >> 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 - > -- Angular momentum makes the world go 'round. --------------1B9FC926105D4976BCAC8E4E Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Meld is an excellnet file compare program.

On 6/28/21 6:41 AM, koff10 wrote:
Thanks lot,
I did not think about it
koff

Le 28/06/2021 à 13:26, Holger Jakobs a écrit :
Dump them using pg_dump and compare the files.

Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 <koff10@hotmail.com>:

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 -


--
Angular momentum makes the world go 'round.
--------------1B9FC926105D4976BCAC8E4E--