On Wed, 2007-07-18 at 16:02 +0200, Csaba Nagy wrote: > On Wed, 2007-07-18 at 15:36, Michael Dengler wrote: > > Row X is inserted into TableX in DB1 on server1....TableX trigger > > function fires and contacts DB2 on server2 and inserts the row into > > TableY on server2. > This kind of problem is usually solved more robustly by inserting the > "change" into a local table and let the remote server (or some external
If you don't want to build your own push/pull system [actually hard to do well] then use something like xmlBlaster or some other MOM. You get logging, transactions, and other features thrown in. http://www.xmlblaster.org/xmlBlaster/doc/requirements/contrib.replication.html -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq