I am trying to do a connection between tables/fields between our Postgresql database and an Oracle database. When updates are made in one it needs to be as closely as possible updated in the other, back and forth. I have tried to install the UnixODBC rpms (and others), but to no avail. We are mired in thousands of dependencies that seem to go on forever! Each time I seem to be close to possibly getting it to install it comes back needing even more RPMs. There must be a solution out there that will allow me to accomplish this without all this headache. Anything anyone can suggest would be appreciated.

  • The one solution to accomplish this without much effort is to hire someone who will do it for you. – mustaccio Mar 19 '19 at 19:53
  • Why don't you use a foreign table? – a_horse_with_no_name Mar 19 '19 at 20:13

You are looking for a master-master-replication between oracle and PostgreSQL ? As mentioned in comments you should use foreign tables for. For example you can use the oracle_fdw extension to integrate your oracle tables into PostgreSQL. You need to complie the extension with your oracle client libraries. The extension you can found here https://github.com/laurenz/oracle_fdw

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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