By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 1,783 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

creating a trigger to remote database

P: 19
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.
Oct 21 '09 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
It look's like job for Slony. Look for manual at www.slony.info
Oct 21 '09 #2

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

Thanks again.
Oct 22 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.