Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

3 Answers 3

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

 
discard

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.