How to update Remote DB using trigger?

"Natrayan Kuppusamy - CTD , Chennai" <[email protected]> Thu, 8 Sep 2005 14:28:42 +0530
Newsgroups gmane.comp.db.postgresql.cygwin
Message-ID <[email protected]>
Hi,

I am using two Postgre databases in my application. Both are in different in
machine.
My requirement is that when one database(primary) gets updated then the
another database(secondary) should also get updated with the same
information updated in primary database.
I think trigger will help in this.
But I am not sure about the connection to remote database from stored
procedure.
Can anyone help me?

Regards,
Natrayan.
DISCLAIMER=20
This message and any attachment(s) contained here are information that is c=
onfidential, proprietary to HCL Technologies=20
and its customers. Contents may be privileged or otherwise protected by law=
. The information is solely intended for the=20
individual or the entity it is addressed to. If you are not the intended re=
cipient of this message, you are not authorized to=20
read, forward, print, retain, copy or disseminate this message or any part =
of it. If you have received this e-mail in error,=20
please notify the sender immediately by return e-mail and delete it from yo=
ur computer


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster