On 2009-01-17, Darren Govoni <dar...@ontrenet.com> wrote: > Hi, > I'm looking for a trigger (any language) that can clone the inserted > row and insert it in another postgres server elsewhere. Is this > possible? Practical? Thoughts? > > I know there are some replication systems out there, but I'm hoping a > simple trigger will suffice since I only need to clone one row at a time > on insert.
that can probably be done (using C for instance) , but do you really want the penalty of every insert waiting for a connection to be established to the remote server? some other systems use the trigger to insert the nes column into holding a table and trigger a notify, then a separate application waiting for the notify retreives the row and inserts it onto the remote server. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
