Postgres Pro
Downloads
Home   >   mailing lists

Thread: Data comparison

Data comparison

From
Harish Harish
Date:
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

Re: Data comparison

From
Muhammad Usman Khan
Date:
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

Re: Data comparison

From
Kashif Zeeshan
Date:
Hi 

You can also use pgAdmin for schema comparison, please check the below link.


Thanks
Kashif Zeeshan

On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <usman.k@bitnine.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

Re: Data comparison

From
Mukesh Rajpurohit
Date:

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 <kashi.zeeshan@gmail.com> wrote:
Hi 

You can also use pgAdmin for schema comparison, please check the below link.


Thanks
Kashif Zeeshan

On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <usman.k@bitnine.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

Re: Data comparison

From
Wasim Devale
Date:

also we can use pg_collector report

Thanks,
Wasim

On Mon, 12 Aug, 2024, 5:09 pm 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 <kashi.zeeshan@gmail.com> wrote:
Hi 

You can also use pgAdmin for schema comparison, please check the below link.


Thanks
Kashif Zeeshan

On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <usman.k@bitnine.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

Re: Data comparison

From
manish yadav
Date:
Hi Harish,

You may explore Livecompare i.e. https://www.enterprisedb.com/docs/livecompare/latest/ to compare the data in two
differentinstances. 


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 *
fromtarget_table;) and vice versa. Thanks. 

On Mon, Aug 12, 2024, 4:47 PM Kashif Zeeshan <kashi.zeeshan@gmail.com> 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%20under,click%20on%20the%20Compare%20button.
>
> Thanks
> Kashif Zeeshan
>
> On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <usman.k@bitnine.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.sqldiff /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 <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
>>>
>>
>

Re: Data comparison

From
Harish Harish
Date:
Thank you very much everyone for your help.

Regards
Hari

On Mon, Aug 12, 2024 at 5:27 PM manish yadav <manishy174@yahoo.co.in> 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 <kashi.zeeshan@gmail.com> 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%20under,click%20on%20the%20Compare%20button.
>
> Thanks
> Kashif Zeeshan
>
> On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <usman.k@bitnine.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
>>
>> 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 help.
>>>
>>> Regards,
>>> Hari
>>>
>>
>