Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Node management functions

BDR uses functions to manage the addition and removal of nodes and related replication control functions. 

The following functions exist to manage nodes:

bdr.bdr_subscribe

The function bdr.bdr_subscribe has been removed from BDR. For uni-directional replication, look at the pglogical project project or tools like Londiste.

Node management function examples

These examples show libpq connection strings without a host or hostadd.
To create a BDR group on 'node1':
    SELECT bdr.bdr_group_create(
       local_node_name := 'node1',
       node_external_dsn := 'port=5598 dbname=bdrdemo');
   
To join 'node2' to BDR group created above:
    SELECT bdr.bdr_group_join(
       local_node_name := 'node2',
       node_external_dsn := 'port=5559 dbname=bdrdemo',
       join_using_dsn := 'port=5558 dbname=bdrdemo');
   
To remove 'node2' from the BDR group created above:
   SELECT bdr.bdr_part_by_node_names('{node2}');
   
To see if your node is ready for replication (if you see a NULL result set, your node is ready):
   SELECT bdr.bdr_node_join_wait_for_ready();

Comments

Popular posts from this blog

2017 Shortern URL - Other Website Like ADFOC.US

How to Repair Corrupt database postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform

PostgreSQL pgBadger