Thread: Comparing two postgres dump files.

Comparing two postgres dump files.

From

Kaushal Shriyan

Date:

03 December 2015, 09:12:37

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

Re: Comparing two postgres dump files.

From

Nicolas Paris

Date:

03 December 2015, 12:58:08

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)