From: Michael Dengler <michael.dengler@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to use a trigger to write rows to a remote server
Date: Wed, 18 Jul 2007 12:30:56 -0400
Message-ID: <e8733d090707180930t12f701edn728cdc486f035cd5@mail.gmail.com> (raw)
In-Reply-To: <18352.1184770316@sss.pgh.pa.us>
References: <e8733d090707180636q45bb5d16vff3e79c2d60d2e83@mail.gmail.com>
<18352.1184770316@sss.pgh.pa.us>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: michael.dengler@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: How to use a trigger to write rows to a remote server
In-Reply-To: <e8733d090707180930t12f701edn728cdc486f035cd5@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox