| Lists: | pgsql-general |
|---|
| From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Getting UDR up and running |
| Date: | 2015-05-05 15:17:26 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi All;
2 questions about UDR:
1) is there documentation showing how to get a one way node (UDR) up and
running?
2) Is it possible to push to a node one way (via UDR) from a BDR node
(i.e. a set of BDR nodes for H/A and a single UDR node to serve up
replication one way as the source for a DSS/Reporting node)
Thanks in advance
| From: | cchee-ob <carter(dot)chee(at)objectbrains(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Getting UDR up and running |
| Date: | 2015-05-07 16:32:56 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
I used the BDR 0.10.0 Documentation to set up UDR.
Basically you set the UDR node the same way as a BDR node and you use the
bdr.bdr_subscribe function to subscribe to the node that you ran the
brr.bdr_group_create function on.
It works great!
The only caveat is that if you are running any DDL on the UDL node you must
use the bdr.bdr_replicate_ddl_command function to execute the DDL only on
the UDR node.
Carter
--
View this message in context: http://postgresql.nabble.com/Getting-UDR-up-and-running-tp5848054p5848331.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.