Postgres Pro
Downloads
Home   >   mailing lists

Re: Comparing two postgres dump files. - Mailing list pgsql-general

From Nicolas Paris
Subject Re: Comparing two postgres dump files.
Date
Msg-id CA+ssMOT_raiwmWhZmksNxTvKC+mMYqNCr3ADgaGTvMX3r61d9g@mail.gmail.com
Whole thread Raw
In response to Comparing two postgres dump files.  (Kaushal Shriyan <kaushalshriyan@gmail.com>)
List pgsql-general
Tree view
2015-12-03 7:12 GMT+01:00 Kaushal Shriyan <kaushalshriyan@gmail.com>:
Hi,

Are there any scripts which will diff two pg_dump files for t1 and t2 time period. For example pg_dump taken on t1 -> 01/11/2015 and then on t2 -> 30/11/2015.

backup_01112015.dump (dump taken on 01/11/2015)
backup_30112015.dump (dump taken on 30/11/2015)

Any help will be highly appreciable.

Regards,

Kaushal

​Hello,

Vim does that great (take a look at vimdiff)
​

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: how to import "where exists（subquery）" EXISTS CONDITION performance?
Next
From: Nguyễn Trần Quốc Vinh
Date:
Subject: Re: fast refresh materialized view