MySQL to PostgreSQL replication

Solution 1:

Postgres 9.1 supports so-called "foreign data wrappers" which allow you to interact with third-party products, e.g. MySQL, Oracle or even non-relational stuff like text files and Reddis. Check it out:

  • http://wiki.postgresql.org/wiki/Foreign_data_wrappers
  • http://pgxn.org/dist/mysql_fdw/