Software for automatic schema compare for PostgreSQL

Could you tell me the tool for automatic comparison of PostgreSQL schemas on different databases. Used for MySQL SQLyog. Now I write a migration by hand, and different data dictionaries to overtake — it's hard. Who uses what or how gets out?

UPD: we use:
a) to compare schemas — apgdiff
b) to compare data LEFT JOIN %)
October 14th 19 at 12:30
5 answers
October 14th 19 at 12:32
EMS DB Comparer for PostgreSQL www.sqlmanager.net/en/products/postgresql/dbcomparer
you can even be a script to try — snippets.dzone.com/posts/show/949
Linux would. The first tried under wine is buggy - albertha.Jer commented on October 14th 19 at 12:35
and the second and under Linux will work - daron_Armstrong commented on October 14th 19 at 12:38
Instead of the second is apgdiff, which is satisfied. And he did not know how to compare data in tables - albertha.Jer commented on October 14th 19 at 12:41
October 14th 19 at 12:34
To compare schemas, you can use PgMDD. The procedure is simple.

1. Do Reverse Engineering one
2. For the resulting model run Modify, as the target referred to the other.
3. Received DDL statements is diff.
October 14th 19 at 12:36
the difference between the physical models are very good in sybase powerdesigner to watch — but
1. under Windows, under Wayne really buggy and hard to cut to the point to at least create a workspace.
2. trial or...
October 14th 19 at 12:38
Junk certainly creepy, but suddenly will do or thinking what will induce (he really is long in the direction of the elephant was not looking, but this thing was once used) — PostgreSQL Diff Utility.
apgdiff, unlike this project is not dead and better - albertha.Jer commented on October 14th 19 at 12:41
October 14th 19 at 12:40
Data to compare/senkat can rubyrep — good job to throw to sezincote two bases. The truth of the schema he does not know how to compare and Cinca scheme should be the same

Find more questions by tags PostgreSQLMigration of data