From: alfranio correia junior <alfranio@lsd.di.uminho.pt>
To: Markus Schiltknecht <markus@bluegap.ch>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: standard interfaces for replication providers
Date: Tue, 08 Aug 2006 19:37:18 +0100
Message-ID: <44D8D9DE.50000@lsd.di.uminho.pt> (raw)
In-Reply-To: <44D8D334.5050808@bluegap.ch>
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>
<44D8D334.5050808@bluegap.ch>
Markus Schiltknecht wrote:
>
> 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.
Of course not...
It is impossible to build a replication system entirely by only using
triggers...
But definitely, there is a set of common requirements among a variety of
replication systems. Moreover, such requirements are also useful to
other systems as well.
Roughly, the GAPI reflects any event inside a database system and allows
any application to intercept and modify them.
For instance, an event might be:
1 - database shutdown, startup
2 - connection shutdown, startup
3 - statement reception
4 - parsing
5 - execution plan generation
6 - tuples written
Our current prototype covers some of them and some of them partially (2,6).
Besides, we also need the priority mechanism.
Best regards,
Alfranio Junior.
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: alfranio@lsd.di.uminho.pt, markus@bluegap.ch, cbbrowne@acm.org
Subject: Re: standard interfaces for replication providers
In-Reply-To: <44D8D9DE.50000@lsd.di.uminho.pt>
* 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