Re: [HACKERS] standard interfaces for replication providers

2006-08-10 Thread Jim Nasby
On Aug 10, 2006, at 12:29 PM, alfranio correia junior wrote: One of the great things about Oracle is that they expose a hell of a lot of the technology they use to build features like replication; ie: take a look at DBMS_*. If I am not wrong such procedures are only for administrative purpo

Re: [HACKERS] standard interfaces for replication providers

2006-08-10 Thread alfranio correia junior
> > Why reinvent the wheel for everything if there was an interface that > offered some of the needed functionality? Maybe PostgreSQL-R is simply > too deep in the database for any of this to be useful, but I'm 99% > certain that Slony could make use of some of this stuff, such as a hook > on tu

Re: [HACKERS] standard interfaces for replication providers

2006-08-10 Thread José Orlando Pereira
On Wednesday 09 August 2006 20:57, Hannu Krosing wrote: > > > > Why reinvent the wheel for everything if there was an interface that > > offered some of the needed functionality? Maybe PostgreSQL-R is simply > > too deep in the database for any of this to be useful, but I'm 99% > > certain that Slo

Re: [HACKERS] standard interfaces for replication providers

2006-08-09 Thread Hannu Krosing
Ühel kenal päeval, K, 2006-08-09 kell 13:56, kirjutas Jim C. Nasby: > On Wed, Aug 09, 2006 at 07:33:35AM +, Markus Schiltknecht wrote: > > Hello Alfranio, > > > > alfranio correia junior wrote: > > >Of course not... > > >It is impossible to build a replication system entirely by only using > >

Re: [HACKERS] standard interfaces for replication providers

2006-08-09 Thread Jim C. Nasby
On Wed, Aug 09, 2006 at 07:33:35AM +, Markus Schiltknecht wrote: > Hello Alfranio, > > alfranio correia junior wrote: > >Of course not... > >It is impossible to build a replication system entirely by only using > >triggers... > > Hm, I don't think it's impossible, just unpractical. Anyway, if

Re: [HACKERS] standard interfaces for replication providers

2006-08-09 Thread Markus Schiltknecht
Hello Alfranio, alfranio correia junior wrote: Of course not... It is impossible to build a replication system entirely by only using triggers... Hm, I don't think it's impossible, just unpractical. Anyway, if you say so yourself, I really doubt the use of GAPI. If you need to create your ow

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread Jose Orlando Pereira
On Tuesday 08 August 2006 15:24, Markus Schiltknecht wrote: > > An API is always limiting. Which is a good thing when you are not the one using it but the one committing to support it. :-) > I still feel that I would need ways too many hooks. Especially when you > consider advanced replication f

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread Jose Orlando Pereira
On Tuesday 08 August 2006 17:44, 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. > > In the case of PostgresQL, at least, operating in Java means that you > need t

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread alfranio correia junior
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

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread alfranio correia junior
Markus Schiltknecht wrote: > Hi, > > Jose Orlando Pereira wrote: >> Sorry, stuff was put twice in the zip file making it somewhat >> confusing. It is in >> postgresql-g-0.1/javasrc/GordaInterfaces/docs/gapi.pdf or directly on >> the web site at http://gorda.di.uminho.pt/download/reports/gapi.pdf. >

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread Markus Schiltknecht
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 ad

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Markus Schiltknecht) wrote: > I'm operating a level deeper with Postgres-R and really enjoy the > freedom I have with C. Having to write a hook or trigger for every > change in the database systems seems a lot of work, which I tend to > postpone unti

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread Markus Schiltknecht
Hi, Jose Orlando Pereira wrote: Sorry, stuff was put twice in the zip file making it somewhat confusing. It is in postgresql-g-0.1/javasrc/GordaInterfaces/docs/gapi.pdf or directly on the web site at http://gorda.di.uminho.pt/download/reports/gapi.pdf. Thank you. I've just had a quick glance

Re: [HACKERS] standard interfaces for replication providers

2006-08-08 Thread alfranio correia junior
Markus Schiltknecht wrote: > Hi, > > José Orlando Pereira wrote: >> I would argue that people haven't been able to build production-grade >> multi-master replication, in part, due to the barrier of not having a >> "standard" database-agnostic API. :-) >> >> In fact, the problem is not the lack of a

Re: [HACKERS] standard interfaces for replication providers

2006-08-07 Thread Jose Orlando Pereira
On Monday 07 August 2006 10:58, Markus Schiltknecht wrote: > > Where do I find the included technical report? Sorry, stuff was put twice in the zip file making it somewhat confusing. It is in postgresql-g-0.1/javasrc/GordaInterfaces/docs/gapi.pdf or directly on the web site at http://gorda.di.um

Re: [HACKERS] standard interfaces for replication providers

2006-08-07 Thread Markus Schiltknecht
Hi, José Orlando Pereira wrote: I would argue that people haven't been able to build production-grade multi-master replication, in part, due to the barrier of not having a "standard" database-agnostic API. :-) In fact, the problem is not the lack of a "standard" API but the lack of an API at

Re: [HACKERS] standard interfaces for replication providers

2006-08-04 Thread José Orlando Pereira
On Friday 04 August 2006 16:46, Tom Lane wrote: > We haven't been able to build production-grade multi-master replication > without the barrier of a "standard" database-agnostic API, so I kinda > doubt that it will work all that much better with one. See Slony-II. I would argue that people haven'

Re: [HACKERS] standard interfaces for replication providers

2006-08-04 Thread Tom Lane
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > On 8/4/06, alfranio correia junior <[EMAIL PROTECTED]> wrote: >> patches to the PostgreSQL server and a plugin provide the necessary >> functionality with minimal intrusion. > I haven't looked at the patch for this in awhile, but does anyone have > a

Re: [HACKERS] standard interfaces for replication providers

2006-08-04 Thread Jonah H. Harris
On 8/4/06, alfranio correia junior <[EMAIL PROTECTED]> wrote: patches to the PostgreSQL server and a plugin provide the necessary functionality with minimal intrusion. I haven't looked at the patch for this in awhile, but does anyone have anything against it? I personally like the triggers and

[HACKERS] standard interfaces for replication providers

2006-08-04 Thread alfranio correia junior
Hi, We have just released an add-on to PostgreSQL supporting the GORDA Architecture and Programming Interface (GAPI). This opens up support for DBMS independent replication middleware, aimed at eager and multi-master replication in clusters and WANs. The implementation of the GAPI is achieved in