Postgres Pro
Downloads
Home   >   mailing lists

Re: Data comparison - Mailing list pgsql-admin

From Muhammad Usman Khan
Subject Re: Data comparison
Date
Msg-id CAPnRvGv+2+pjDM7YdVudBmLnsEtCUwXsKk-dPfNP2-xU8bwD6Q@mail.gmail.com
Whole thread Raw
In response to Data comparison  (Harish Harish <hpt3009@gmail.com>)
Responses Re: Data comparison
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Harish Harish
Date:
Subject: Data comparison
Next
From: Kashif Zeeshan
Date:
Subject: Re: Data comparison