We used apgdiff for automated schema diff generation. 2.4 was released many years ago and lacks compatibility with PG 10. Looking for alternatives. Thanks for the mentions.
Edit - Migra does not compare pgdump outputs.
Edit - Migra does not compare pgdump outputs.
I've found that the best parser of PostgreSQL dump files is PostgreSQL, and don't want to reimplement that.
Hence, migra works directly on database connections. If you have a dump file you want to compare, you can just create a temporary database and load the dump into that first. There's an example in the docs of how to do this easily.