Comparing two postgres dump files

postgresql pg-dump
Rohita Khatiwada picture Rohita Khatiwada · Apr 19, 2011 · Viewed 7.6k times · Source

How to compare postgres dump files? I have two dump files, dump1 and dump2 . And I want to compare these two dump files.

Any help will be appreciated..

Thank you

Answer

Bhargav Modi picture Bhargav Modi · Dec 1, 2014

You can use beyond compare if windows is been used and use kompare if linux(fedora) is been used also if linux is used than you can use different command like sdiff example is provided in this link, other commands are diff,comm -23 filedump1 fuledump2,sort filedump1 > filedump1.sorted sort fuledump2 > fuledump2.sorted diff filedump1.sorted fuledump2.sorted etc are utilities to compare text in files

Related questions

Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_dump: aborting because of server version …

Read More
How to create a backup of a single table in a postgres database?

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work with the pg_dump command?

Read More
How do I do a schema only backup and restore in PostgreSQL?

How do I take a schema level backup in PostgreSQL database and restore on the another database? Is there any single command available for this? For example, can I pg_dump and restore in single line?

Read More