Getting UDR up and running

Started by CS DBAalmost 11 years ago2 messagesgeneral
Jump to latest
#1CS DBA
cs_dba@consistentstate.com

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2cchee-ob
carter.chee@objectbrains.com
In reply to: CS DBA (#1)
Re: Getting UDR up and running

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general