Date: Mon, 12 Aug 2024 11:57:29 +0000 (UTC)
From: manish yadav <manishy174@yahoo.co.in>
Reply-To: manish yadav <manishy174@yahoo.co.in>
To: "kashi.zeeshan@gmail.com" <kashi.zeeshan@gmail.com>,
	Mukesh Rajpurohit <vivasvan1902@gmail.com>
Cc: "usman.k@bitnine.net" <usman.k@bitnine.net>,
	"hpt3009@gmail.com" <hpt3009@gmail.com>,
	"pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Message-ID: <838274018.4237241.1723463849156@mail.yahoo.com>
In-Reply-To: 
 <CAL+ptAAdXVDcxs_-KndF7B8bV4Fx8KHR5xEuBOZQj5=PThpj8w@mail.gmail.com>
References: 
 <CANc-nPt0WFbMBYPUKht1anxtOp5aC5JW=MZBb5y6oF1geO1=SQ@mail.gmail.com>
 <CAPnRvGv+2+pjDM7YdVudBmLnsEtCUwXsKk-dPfNP2-xU8bwD6Q@mail.gmail.com>
 <CAAPsdhc8ym3JJ_wP7yxzC_9dmCVhahMKeGriC6W8robDBRzouw@mail.gmail.com>
 <CAL+ptAAdXVDcxs_-KndF7B8bV4Fx8KHR5xEuBOZQj5=PThpj8w@mail.gmail.com>
Subject: Re: Data comparison
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Length: 1829
Archived-At: 
 <https://www.postgresql.org/message-id/838274018.4237241.1723463849156%40mail.yahoo.com>
Precedence: bulk

Hi Harish,

You may explore Livecompare i.e.=C2=A0https://www.enterprisedb.com/docs/liv=
ecompare/latest/=C2=A0to 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:=20


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> wrot=
e:
> Hi=C2=A0
>=20
> You can also use pgAdmin for schema comparison, please check the below li=
nk.
>=20
> https://www.pgadmin.org/docs/pgadmin4/8.8/schema_diff.html#:~:text=3DClic=
k%20on%20Schema%20Diff%20under,click%20on%20the%20Compare%20button.
>=20
> Thanks
> Kashif Zeeshan
>=20
> On Mon, Aug 12, 2024 at 3:48=E2=80=AFPM Muhammad Usman Khan <usman.k@bitn=
ine.net> 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 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
>>=20
>> Adjust your ports and databases name accordingly
>>=20
>> RegardsMuhammad Usman Khan
>>=20
>>=20
>>=20
>> On Mon, 12 Aug 2024 at 15:41, Harish Harish <hpt3009@gmail.com> wrote:
>>> Dear Admins
>>>=20
>>> Is there any way to do data comparison for the database scheme in Postg=
reSQL between old version(10) and new version (15.0).
>>>=20
>>> Just migrated database from version 10 to 15.
>>>=20
>>> Much appreciate your=C2=A0help.
>>>=20
>>> Regards,
>>> Hari
>>>=20
>>=20
>=20