Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdjli-000TJA-0J for pgsql-admin@arkaria.postgresql.org; Tue, 13 Aug 2024 05:08:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sdjlf-001dZW-Ib for pgsql-admin@arkaria.postgresql.org; Tue, 13 Aug 2024 05:08:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdjlf-001dZO-3X for pgsql-admin@lists.postgresql.org; Tue, 13 Aug 2024 05:08:23 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sdjlY-004aoh-B8 for pgsql-admin@lists.postgresql.org; Tue, 13 Aug 2024 05:08:22 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id 3f1490d57ef6-dff17fd97b3so4798286276.2 for ; Mon, 12 Aug 2024 22:08:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723525694; x=1724130494; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=cayFZxydEko9TqAw4hZqfe0aFId+GRKmwxU/CGldxko=; b=goWwYDk/+DrraE42rMYU2ku6d3W3Pujf2McrRsOP7Xcvuuxg+9g9w7rbkCTsAUEG3J mi2azHC4VAX9THTdbVMCIK45YtCkLfhsrZ4z0CwDB5/UOUifVfO+5gESU2YQIKQV/m4P 7bxOWzieiuQdY4sZusm9CdoTkiJfH1TEo/PJpgVSxRg0Hxk/MXIIUomhdNgfm3BF5mps d4aq+F2eITfFiOVWKNypWSfyqeH83BCV25Yc6mjGox3bWVurR7xt1rWxJR2PPDIbSTlW hzgxx5M0dicbD81it1eKHugCHMeByf/+NGOFXbhPZpXHMvZPiW1TeIqJCN16rSxWlkMr A37A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723525694; x=1724130494; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=cayFZxydEko9TqAw4hZqfe0aFId+GRKmwxU/CGldxko=; b=lxCjc0m3xK03O85CKZEpmK/MWyax54f2tZQLv8i+zT+pC4TyesAuRqc75h7KKSq3Lc uQuoqlDsXgQZ6tsonBUvBzfddXlzqHO9L652fObawN5iLJLl6VtNyKUdJqKPdnMZDqwX VOi3l/evdIYN8FUnJa6AP9oERz2KvJP1m0Hgv/w066sxcG9S8sVgmVS3yNL1acUqnXNC ePhX9Zudr0JfAtKcBL2cjD+jpQnhktVybk+lwr4xLJyHNVESm6geV3qvLO7r7oMFDBTV 41G773xci1PPYZF2h9N4LOEkczTpBmhrDZbKBgMbHAp3YnQCnfjecsjanws5QpQL9eeN Jkfg== X-Forwarded-Encrypted: i=1; AJvYcCWjN4SYFS5aOwxdzyYhXFc/fxRcs9iBaznbdpFuFYoodAsT34DWk3zC+xssv7QVHQIZt89sSa18dHAfWg==@lists.postgresql.org X-Gm-Message-State: AOJu0YzyZ/dpWLwW5OgxpKC+zN297qwNy40Gjd94PgidRm7zsKaWW6y3 O8CI0sw9dOklvtbJshr6yy9IcahSPy6Izkcib7UmpfdADx6zWfw+L32yhUHJ/LcVPVklfWCBRWX EnrBxwY4dcOpD5klvaqscqyRvtBM= X-Google-Smtp-Source: AGHT+IFo2+Zk+9IRdzQUK3rM6td5U4dYPQAfdsJlFwdEeayvnwwg1tzVRFNOOPADFGcwA4OgrluGgPRxGIu7KJas1Gc= X-Received: by 2002:a05:6902:a83:b0:e0b:e550:4e46 with SMTP id 3f1490d57ef6-e113cd62453mr3095974276.5.1723525694199; Mon, 12 Aug 2024 22:08:14 -0700 (PDT) MIME-Version: 1.0 References: <838274018.4237241.1723463849156@mail.yahoo.com> In-Reply-To: <838274018.4237241.1723463849156@mail.yahoo.com> From: Harish Harish Date: Tue, 13 Aug 2024 10:37:36 +0530 Message-ID: Subject: Re: Data comparison To: manish yadav Cc: "kashi.zeeshan@gmail.com" , Mukesh Rajpurohit , "usman.k@bitnine.net" , "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000c3a3ee061f899831" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c3a3ee061f899831 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thank you very much everyone for your help. Regards Hari On Mon, Aug 12, 2024 at 5:27=E2=80=AFPM manish yadav wrote: > Hi Harish, > > You may explore Livecompare i.e. > https://www.enterprisedb.com/docs/livecompare/latest/ to compare the data > in two different instances. > > > Thanks and Regards, > > Manish Yadav > > > > > > > > > On Monday, 12 August 2024, 05:09:54 PM IST, Mukesh Rajpurohit < > vivasvan1902@gmail.com> wrote: > > > > > > Hi Harish, > You can use EXCEPT operator for this purpose, i.e > (select * from source_table except select * from target_table;) and vice > versa. Thanks. > > On Mon, Aug 12, 2024, 4:47 PM Kashif Zeeshan > wrote: > > Hi > > > > You can also use pgAdmin for schema comparison, please check the below > link. > > > > > https://www.pgadmin.org/docs/pgadmin4/8.8/schema_diff.html#:~:text=3DClic= k%20on%20Schema%20Diff%20under,click%20on%20the%20Compare%20button > . > > > > Thanks > > Kashif Zeeshan > > > > On Mon, Aug 12, 2024 at 3:48=E2=80=AFPM Muhammad Usman Khan > wrote: > >> Dear Harish,If you are referring to data validation then the following > query might give you the desired results/pg_dump -U postgres -s target -p > 5334 > /tmp/db2_schema.sql ./pg_dump -U postgres -s source > > /tmp/db1_schema.sql diff /tmp/db1_schema.sql /tmp/db2_schema.sql > >> > >> Adjust your ports and databases name accordingly > >> > >> RegardsMuhammad Usman Khan > >> > >> > >> > >> On Mon, 12 Aug 2024 at 15:41, Harish Harish wrote: > >>> Dear Admins > >>> > >>> Is there any way to do data comparison for the database scheme in > PostgreSQL between old version(10) and new version (15.0). > >>> > >>> Just migrated database from version 10 to 15. > >>> > >>> Much appreciate your help. > >>> > >>> Regards, > >>> Hari > >>> > >> > > > > --000000000000c3a3ee061f899831 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thank=C2=A0you very much everyone=C2=A0for your help.
=
Regards
Hari

On Mon, Aug 12, 2024 at 5:27=E2= =80=AFPM manish yadav <manishy= 174@yahoo.co.in> wrote:
Hi Harish,

You may explore Livecompare i.e.=C2=A0https://w= ww.enterprisedb.com/docs/livecompare/latest/=C2=A0to compare the data i= n two different instances.


Thanks and Regards,

Manish Yadav








On Monday, 12 August 2024, 05:09:54 PM IST, Mukesh Rajpurohit <vivasvan1902@gmail.com= > wrote:





Hi Harish,
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 You can use EXCEPT oper= ator for this purpose, i.e (select * from source_table except select * from= target_table;) and vice versa. Thanks.

On Mon, Aug 12, 2024, 4:47 PM Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote: > Hi=C2=A0
>
> You can also use pgAdmin for schema comparison, please check the below= link.
>
> https://www.pgadmin.org/docs/pg= admin4/8.8/schema_diff.html#:~:text=3DClick%20on%20Schema%20Diff%20under,cl= ick%20on%20the%20Compare%20button.
>
> Thanks
> Kashif Zeeshan
>
> On Mon, Aug 12, 2024 at 3:48=E2=80=AFPM Muhammad Usman Khan <usman.k@bitnine.net&= gt; wrote:
>> Dear=C2=A0Harish,If you are referring=C2=A0to data validation=C2= =A0then the following query might give you the desired results/pg_dump -U p= ostgres -s target -p 5334 > /tmp/db2_schema.sql ./pg_dump -U postgres -s= source > /tmp/db1_schema.sql diff /tmp/db1_schema.sql /tmp/db2_schema.s= ql
>>
>> Adjust your ports and databases name accordingly
>>
>> RegardsMuhammad Usman Khan
>>
>>
>>
>> On Mon, 12 Aug 2024 at 15:41, Harish Harish <hpt3009@gmail.com> wrote:
>>> Dear Admins
>>>
>>> Is there any way to do data comparison for the database scheme= in PostgreSQL between old version(10) and new version (15.0).
>>>
>>> Just migrated database from version 10 to 15.
>>>
>>> Much appreciate your=C2=A0help.
>>>
>>> Regards,
>>> Hari
>>>
>>
>

--000000000000c3a3ee061f899831--