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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to