Postgres wire compatibility does not imply Postgres compatibility. I recently got bit by this, I wanted to convert a mail address database from MySQL Galera to

Postgres wire compatibility does not imply Postgres compatibility. I recently got bit by this, I wanted to convert a mail address database from MySQL Galera to CockroachDB, because CockroachDB was just a bit easier to deal with. Unfortunately, Cockroach only support UTF-8, and Postgres only supports LATIN1 for the database (compiled into code). I believe that there are reasons for both sides to make this choice, unfortunately it turned what I hoped would be a slam dunk into a round peg in a square hole.