Hmm..I was hoping to avoid personal insults....
Anyway, Nuts or not...what I am attempting is to simply have row from one table inserted into another servers DB I don't see it as replication because:
a) The destination table will have a trigger that modifies the arriving data to fit its table scheme.
b) It is not critical that the data be synchronous (ie a lost row on the destination DB is not a big deal)
c) I see as more of a provision of data to the destination DB NOT A REPLICATION OF DATA.
Essentially the remote server just wants to know when some record arrives at the source server and wants to know some of the info contained in the new record.
And yes it may be that I know little about the myriad of problems involved with replication...but I do know how to carry on a civil, adult conversation....maybe we can have a knowledge exchange.
Cheers
Mike
On 7/18/07, Tom Lane <tgl@sss.pgh.pa.us> wrote: "Michael Dengler" <michael.dengler@gmail.com> writes:
> I am trying to find out how to use a trigger function on a table to copy any
> inserted row to a remote PG server.
> ...
> This is not replication, I'm not interested in a full blown trigger based
> replication solution.
To be blunt, you're nuts. You *are* building a trigger based
replication system, and the fact that you think you can cut corners
just shows how little you know about the problems involved.
Use Slony, or some other solution that someone else has already gotten
the bugs out of.
regards, tom lane