Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?

share|improve this question

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:

share|improve this answer
that (in theory) can be useful to PG=>MY replication using triggers, but not back :( – datacompboy Apr 7 '12 at 11:26

Not sure if there are opensource tools, but GoldenGate which was acquired by Oracle claims to replicate between any major databases. Now that MySQL is also Oracle I won't be surprised that this is supported, but you should contact them if you are interested. I personally have not used this product but have a friend who used to work in the heterogenous database replicatio there. So this is just a pointer for you.

share|improve this answer

exist pgslony replication tool but I am not sure that can help you, for very easy used is possible write job in postgres, you can try your favorite language, for example python or perl

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.