MIME-Version: 1.0
References: 
 <CANc-nPt0WFbMBYPUKht1anxtOp5aC5JW=MZBb5y6oF1geO1=SQ@mail.gmail.com>
 <CAPnRvGv+2+pjDM7YdVudBmLnsEtCUwXsKk-dPfNP2-xU8bwD6Q@mail.gmail.com>
In-Reply-To: 
 <CAPnRvGv+2+pjDM7YdVudBmLnsEtCUwXsKk-dPfNP2-xU8bwD6Q@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Mon, 12 Aug 2024 16:17:01 +0500
Message-ID: 
 <CAAPsdhc8ym3JJ_wP7yxzC_9dmCVhahMKeGriC6W8robDBRzouw@mail.gmail.com>
Subject: Re: Data comparison
To: Muhammad Usman Khan <usman.k@bitnine.net>
Cc: Harish Harish <hpt3009@gmail.com>, pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000085c8d7061f7aa264"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAPsdhc8ym3JJ_wP7yxzC_9dmCVhahMKeGriC6W8robDBRzouw%40mail.gmail.com>
Precedence: bulk

--00000000000085c8d7061f7aa264
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=3DClick%=
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 <usman.k@bitnin=
e.net>
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
>
> Regards
> Muhammad 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 help.
>>
>> Regards,
>> Hari
>>
>

--00000000000085c8d7061f7aa264
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi=C2=A0<div><br></div><div>You can also use pgAdmin for s=
chema comparison, please check the below link.</div><div><br></div><div><a =
href=3D"https://www.pgadmin.org/docs/pgadmin4/8.8/schema_diff.html#:~:text=
=3DClick%20on%20Schema%20Diff%20under,click%20on%20the%20Compare%20button">=
https://www.pgadmin.org/docs/pgadmin4/8.8/schema_diff.html#:~:text=3DClick%=
20on%20Schema%20Diff%20under,click%20on%20the%20Compare%20button</a>.<br></=
div><div><br></div><div>Thanks</div><div>Kashif Zeeshan</div></div><br><div=
 class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Aug 12=
, 2024 at 3:48=E2=80=AFPM Muhammad Usman Khan &lt;<a href=3D"mailto:usman.k=
@bitnine.net">usman.k@bitnine.net</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><font face=3D"arial, sans=
-serif">Dear=C2=A0Harish,<br>If you are referring=C2=A0to data validation=
=C2=A0then the following query might give you the desired results<br><br><s=
pan style=3D"color:rgb(0,0,0);font-size:13px">/pg_dump -U postgres -s targe=
t -p 5334 &gt; /tmp/db2_schema.sql
./pg_dump -U postgres -s source &gt; /tmp/db1_schema.sql
diff /tmp/db1_schema.sql /tmp/db2_schema.sql</span><br clear=3D"all"></font=
><div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><font fac=
e=3D"arial, sans-serif"><span></span></font><div><font face=3D"arial, sans-=
serif"><br>Adjust your ports and databases name accordingly</font></div><di=
v><font face=3D"arial, sans-serif"><br></font><div dir=3D"ltr"><div dir=3D"=
ltr"><div><font size=3D"4" face=3D"arial, sans-serif">Regards<br>Muhammad U=
sman Khan</font></div><div><br></div></div></div></div></div></div></div><b=
r></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr=
">On Mon, 12 Aug 2024 at 15:41, Harish Harish &lt;<a href=3D"mailto:hpt3009=
@gmail.com" target=3D"_blank">hpt3009@gmail.com</a>&gt; wrote:<br></div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Dear Admin=
s<div dir=3D"auto"><br></div><div dir=3D"auto">Is there any way to do data =
comparison for the database scheme in PostgreSQL between old version(10) an=
d new version (15.0).</div><div dir=3D"auto"><br></div><div dir=3D"auto">Ju=
st migrated database from version 10 to 15.</div><div dir=3D"auto"><br></di=
v><div dir=3D"auto">Much appreciate your=C2=A0help.</div><div dir=3D"auto">=
<br></div><div dir=3D"auto">Regards,</div><div dir=3D"auto">Hari</div></div=
>
</blockquote></div>
</blockquote></div>

--00000000000085c8d7061f7aa264--