public inbox for [email protected]
help / color / mirror / Atom feedData comparison
7+ messages / 6 participants
[nested] [flat]
* Data comparison
@ 2024-08-12 10:41 Harish Harish <[email protected]>
2024-08-12 10:48 ` Re: Data comparison Muhammad Usman Khan <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Harish Harish @ 2024-08-12 10:41 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Data comparison
2024-08-12 10:41 Data comparison Harish Harish <[email protected]>
@ 2024-08-12 10:48 ` Muhammad Usman Khan <[email protected]>
2024-08-12 11:17 ` Re: Data comparison Kashif Zeeshan <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Muhammad Usman Khan @ 2024-08-12 10:48 UTC (permalink / raw)
To: Harish Harish <[email protected]>; +Cc: [email protected]
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 <[email protected]> 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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Data comparison
2024-08-12 10:41 Data comparison Harish Harish <[email protected]>
2024-08-12 10:48 ` Re: Data comparison Muhammad Usman Khan <[email protected]>
@ 2024-08-12 11:17 ` Kashif Zeeshan <[email protected]>
2024-08-12 11:39 ` Re: Data comparison Mukesh Rajpurohit <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Kashif Zeeshan @ 2024-08-12 11:17 UTC (permalink / raw)
To: Muhammad Usman Khan <[email protected]>; +Cc: Harish Harish <[email protected]>; [email protected]
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=Click%20on%20Schema%20Diff%20unde...
.
Thanks
Kashif Zeeshan
On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <[email protected]>
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 <[email protected]> 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
>>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Data comparison
2024-08-12 10:41 Data comparison Harish Harish <[email protected]>
2024-08-12 10:48 ` Re: Data comparison Muhammad Usman Khan <[email protected]>
2024-08-12 11:17 ` Re: Data comparison Kashif Zeeshan <[email protected]>
@ 2024-08-12 11:39 ` Mukesh Rajpurohit <[email protected]>
2024-08-12 11:44 ` Re: Data comparison Wasim Devale <[email protected]>
2024-08-12 11:57 ` Re: Data comparison manish yadav <[email protected]>
0 siblings, 2 replies; 7+ messages in thread
From: Mukesh Rajpurohit @ 2024-08-12 11:39 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]; [email protected]; [email protected]
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 <[email protected]>
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=Click%20on%20Schema%20Diff%20unde...
> .
>
> Thanks
> Kashif Zeeshan
>
> On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <[email protected]>
> 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 <[email protected]> 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
>>>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Data comparison
2024-08-12 10:41 Data comparison Harish Harish <[email protected]>
2024-08-12 10:48 ` Re: Data comparison Muhammad Usman Khan <[email protected]>
2024-08-12 11:17 ` Re: Data comparison Kashif Zeeshan <[email protected]>
2024-08-12 11:39 ` Re: Data comparison Mukesh Rajpurohit <[email protected]>
@ 2024-08-12 11:44 ` Wasim Devale <[email protected]>
1 sibling, 0 replies; 7+ messages in thread
From: Wasim Devale @ 2024-08-12 11:44 UTC (permalink / raw)
To: Mukesh Rajpurohit <[email protected]>; +Cc: [email protected]; [email protected]; [email protected]; [email protected]
also we can use pg_collector report
Thanks,
Wasim
On Mon, 12 Aug, 2024, 5:09 pm Mukesh Rajpurohit, <[email protected]>
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 <[email protected]>
> 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=Click%20on%20Schema%20Diff%20unde...
>> .
>>
>> Thanks
>> Kashif Zeeshan
>>
>> On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <[email protected]>
>> 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 <[email protected]> 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
>>>>
>>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Data comparison
2024-08-12 10:41 Data comparison Harish Harish <[email protected]>
2024-08-12 10:48 ` Re: Data comparison Muhammad Usman Khan <[email protected]>
2024-08-12 11:17 ` Re: Data comparison Kashif Zeeshan <[email protected]>
2024-08-12 11:39 ` Re: Data comparison Mukesh Rajpurohit <[email protected]>
@ 2024-08-12 11:57 ` manish yadav <[email protected]>
2024-08-13 05:07 ` Re: Data comparison Harish Harish <[email protected]>
1 sibling, 1 reply; 7+ messages in thread
From: manish yadav @ 2024-08-12 11:57 UTC (permalink / raw)
To: [email protected] <[email protected]>; Mukesh Rajpurohit <[email protected]>; +Cc: [email protected] <[email protected]>; [email protected] <[email protected]>; [email protected] <[email protected]>
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 <[email protected]> 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 <[email protected]> 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=Click%20on%20Schema%20Diff%20unde....
>
> Thanks
> Kashif Zeeshan
>
> On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <[email protected]> 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 <[email protected]> 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
>>>
>>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Data comparison
2024-08-12 10:41 Data comparison Harish Harish <[email protected]>
2024-08-12 10:48 ` Re: Data comparison Muhammad Usman Khan <[email protected]>
2024-08-12 11:17 ` Re: Data comparison Kashif Zeeshan <[email protected]>
2024-08-12 11:39 ` Re: Data comparison Mukesh Rajpurohit <[email protected]>
2024-08-12 11:57 ` Re: Data comparison manish yadav <[email protected]>
@ 2024-08-13 05:07 ` Harish Harish <[email protected]>
0 siblings, 0 replies; 7+ messages in thread
From: Harish Harish @ 2024-08-13 05:07 UTC (permalink / raw)
To: manish yadav <[email protected]>; +Cc: [email protected] <[email protected]>; Mukesh Rajpurohit <[email protected]>; [email protected] <[email protected]>; [email protected] <[email protected]>
Thank you very much everyone for your help.
Regards
Hari
On Mon, Aug 12, 2024 at 5:27 PM manish yadav <[email protected]> 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 <
> [email protected]> 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 <[email protected]>
> 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=Click%20on%20Schema%20Diff%20unde...
> .
> >
> > Thanks
> > Kashif Zeeshan
> >
> > On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <[email protected]>
> 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 <[email protected]> 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
> >>>
> >>
> >
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-08-13 05:07 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-12 10:41 Data comparison Harish Harish <[email protected]>
2024-08-12 10:48 ` Muhammad Usman Khan <[email protected]>
2024-08-12 11:17 ` Kashif Zeeshan <[email protected]>
2024-08-12 11:39 ` Mukesh Rajpurohit <[email protected]>
2024-08-12 11:44 ` Wasim Devale <[email protected]>
2024-08-12 11:57 ` manish yadav <[email protected]>
2024-08-13 05:07 ` Harish Harish <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox