I have been searching for a tool that would help me to automate schemas comparison of database instances. My current project is built on top of 15-years old legacy and they got themselves to the situation where instances comparison is required.

I found great stack thread however it's a bit old and tools listed there are also either abandoned or incomplete ( https://stackoverflow.com/questions/4804779/how-to-check-difference-between-two-databases-in-postgresql )

Have anybody had any luck with this kind of problem? If so would you share what you used?