From: Markus Schiltknecht <markus@bluegap.ch>
To: Christopher Browne <cbbrowne@acm.org>
Subject: Re: standard interfaces for replication providers
Date: Tue, 08 Aug 2006 18:08:52 +0000
Message-ID: <44D8D334.5050808@bluegap.ch> (raw)
In-Reply-To: <87irl3uqgx.fsf@wolfe.cbbrowne.com>
References: <44D30B31.2070403@lsd.di.uminho.pt>
<200608041733.24228.jop@lsd.di.uminho.pt>
<44D70EDA.9060602@bluegap.ch>
<200608071940.26750.jop@lsd.di.uminho.pt>
<44D89EA5.5090703@bluegap.ch>
<87irl3uqgx.fsf@wolfe.cbbrowne.com>
Hello Christopher,
Christopher Browne wrote:
> Most databases that are interesting to replicate are implemented in C
> or C++, thereby implying that a suitably "deep" API needs to be
> implemented in C.
I generally agree with you. Although it's probably worth mentioning that
the API they propose adds hooks to PostgreSQL in the form of triggers.
This API comes as a patch is against the PostgreSQL source, thus in C.
The nature of triggers in PostgreSQL would then allow to write
replication systems in whatever language you prefer, as long as there is
a PL/{$LANG} for $LANG = your favorite.
I'm questioning if a replication system can be written by only using
triggers as hooks. AFAIK Slony-I uses triggers, so you can probably
better comment on problems or limitations using triggers. For me a
shared library with some hooks as C function calls seems a more
plausible approach.
Regards
Markus
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-hackers@postgresql.org
Cc: markus@bluegap.ch, cbbrowne@acm.org
Subject: Re: standard interfaces for replication providers
In-Reply-To: <44D8D334.5050808@bluegap.ch>
* 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