creating a trigger to remote database

Hi,

I have to feed database A from database B which are in different machines but in the same network when a insert/update occurs on database B. I decided to use trigger for this and was trying to write a trigger but failed so far.... (I have written triggers in mysql but using pgsql is a bit difficult to me...) It will be so helpful to me if anyone can post a trigger for my scenario.

Please be kind enough to show me better ways to handle this scenario if any alternative ways exists... I have heard that this can be achieved by database replication too but i don't know how to do it.

Thanks in advance.

re: creating a trigger to remote database

It look's like job for Slony. Look for manual at www.slony.info

re: creating a trigger to remote database

Thanks for your reply rski.. It was very helpful. I will try it and get back if i face any problems...

Thanks again.