Comparing two postgres dump files.

Started by Kaushal Shriyanover 10 years ago2 messagesgeneral
Jump to latest
#1Kaushal 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

#2Nicolas Paris
niparisco@gmail.com
In reply to: Kaushal Shriyan (#1)
Re: Comparing two postgres dump files.

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)