Re: Integrating Replication into Core - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Integrating Replication into Core
Date
Msg-id 1164232880.10359.81.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: Integrating Replication into Core  (Markus Schiltknecht <markus@bluegap.ch>)
Responses Re: Integrating Replication into Core
Re: Integrating Replication into Core
List pgsql-hackers
On Wed, 2006-11-22 at 20:31 +0100, Markus Schiltknecht wrote:
> Hi,
> 
> Jeff Davis wrote:
> > Nothing's wrong with that approach. My prediction, however, is that:
> > 
> > (1) Similar replication solutions will first agree on some common hooks
> > they need in the backend that may have no actual SQL syntax associated,
> > and get patches in
> 
> Well, before that, you need to know what hooks you need. And that again 
> involves lots of implementation details. Thus better first implement 
> without hooks, otherwise you might later notice that there is something 
> you didn't think of.

I think you misunderstand my point. I was talking about replication
implementations that already exist. They already have patches on the
backend that are necessary for their solution to work.

The idea is to design a single set of hooks that can be used to
implement an entire class of replication. This only makes sense after
existing solutions come to some agreement. I view that as a first step,
assuming that it is necessary to alter the core in order to implement
the class of replication in question.

Once that step is complete, ideally you'd be able to implement Postgres-
R without having to patch the postgresql backend to accomplish it
(except for maybe adding the syntax for your solution). Then, when a
syntax is agreed upon, you won't need to patch the backend at all. Isn't
that the goal, to be able to implement your replication without patching
the backend?

Regards,Jeff Davis




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FKs + partial indexes?
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Out of memory error causes Abort, Abort tries to allocate memory