Thread: BDR table level selective replication available?

BDR table level selective replication available?

From
Ville Rantamaula
Date:
Hi,

I've been playing around with BDR replication for a couple of months. Really nice work there, and thanks for contribution!

However, there is on matter, that is confusing to me about the current state of the BDR project.

It states on the BDR project web page that selective replication is not available yet:
https://wiki.postgresql.org/wiki/BDR_Project#Selective_Replication_.28Table.2FRow-level_filtering.29
<quote>

Selective Replication (Table/Row-level filtering)

LLSR doesn't yet support selection of data at table or row level, only at database level. It is a design goal to be able to support this in the future.

</quote>


On the other hand it states on the website
http://2ndquadrant.com/en/resources/bdr/
that as of BDR 0.8.0 release, selective replication on table level is available:
<quote>

Selection Replication

BDR 0.8.0 is now available and includes a number of enhancements, including Selective Replication.

Selective Replication allows admins to specify sets of tables that each node should receive changes on. It is now possible to exclude tables that are not of interest to a particular node, or include only a subset of tables for replication to a node.
</quote>

I would guess the former page is simply out of date?

But in addition to that, I could not spot any configuration directives, as how selective replication on table level is configured in any of the PostgreSQL BDR wiki pages?

Would anyone got some pointer or a link to a document describing how table level selective replication ought to be configured with BDR?

Yours,
Ville

Re: BDR table level selective replication available?

From
Simon Riggs
Date:
On 16 February 2015 at 07:33, Ville Rantamaula
<ville.rantamaula@gmail.com> wrote:

> Would anyone got some pointer or a link to a document describing how table
> level selective replication ought to be configured with BDR?

The release will be coming soonish, but I don't have dates or details
yet. We're not looking to rush the process.

Thanks for your interest and patience.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services


Re: BDR table level selective replication available?

From
Ville Rantamaula
Date:
2015-02-16 11:57 GMT+02:00 Simon Riggs <simon@2ndquadrant.com>:
On 16 February 2015 at 07:33, Ville Rantamaula
<ville.rantamaula@gmail.com> wrote:

> Would anyone got some pointer or a link to a document describing how table
> level selective replication ought to be configured with BDR?

The release will be coming soonish, but I don't have dates or details
yet. We're not looking to rush the process.

Sorry, but I'm still quite confused here, about the conflicting information about the availability of selective replication in recent BDR releases.

Is it so, that even though on the 2ndQuandrant BDR web page http://2ndquadrant.com/en/resources/bdr/ it announces:
"BDR 0.8.0 is now available and includes a number of enhancements, including Selective Replication."

Alas the currently publicly released version of BDR (RPM release date 2014-12-27 postgresql-bdr94-bdr-0.8.0beta1-1_2ndQuadrant.el7.centos), which was released soon after PostgreSQL 9.4.0 stable was announced, does not yet contain the selective replication features, but it is the next BDR release reflecting the 2015-02-05 PostgreSQL 9.4.1 release, which will actually contain selective replication - at least on table level?

Yours,
Ville