Data synchronization between Ingres 2006 and postgresql

[giedz]

Hello,

I don't know if it's possible but here is what I need to do: I've got ingres on one machine and postgres on another. When any record in particular table in ingres database is added/deleted/updated I'd like to transfer all this data to postgres.

In postgres i can do such thing using "create function xxx language 'c'...." statement and compiling some code in C to manipulate date.

IS there any chance to do "synchronizaton procedure" in ingres? Perhaps callproc - I'm not very familiar with ingres and its documentation is quite huge. If anyone could send me some hints how to start it... I would be really greatful.

Regards,
Marcin

[daryl.monge]

One technique:

create a rule (trigger) that will raise a database event. Your "language C'' function will be an stand alone executable that listens for the event and processes the data. You would typically want the primary key of the record passed as the event description. The nice additional feature is the process is asynchronous; your transaction in the main database will not be stalled while the data is transmitted to Postgres. The bad part is that is asynchronous...... You will not know in the Ingres transaction if the transfer was successful. It would have to be managed as a separate function.

[bartez]

You should take a look on Hight Volume Replicator(http://hvr.biz) tool but I`m not sure if they have support for postgresql.