Ringer [mailto:cr...@2ndquadrant.com]
Sent: Wednesday, July 12, 2017 11:59 PM
To: Zhu, Joshua <j...@thalesesec.net>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] BDR node removal and rejoin
On 13 July 2017 at 01:56, Zhu, Joshua
<j...@vormetric.com<mailto:j...@vormetric.com>
Hi, I am having difficulty removing a node from a BDR group (with nodes node1
through node5) then rejoin the group.
Prior to removing a node, the BDR is running fine, query on bdr.bdr_nodes table
shows all nodes having the status 'r'.
Here is what I have done for removing node5 and rejoining:
before a removed node (with database dropped and recreated) rejoining a BDR
group.
From: Zhu, Joshua
Sent: Friday, July 07, 2017 2:59 PM
To: 'pgsql-general@postgresql.org' <pgsql-general@postgresql.org>
Subject: BDR node removal and rejoin
Hi, I am having difficulty removing a node from a BDR
[mailto:cr...@2ndquadrant.com]
Sent: Wednesday, July 12, 2017 1:59 AM
To: Zhu, Joshua <j...@thalesesec.net>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] BDR node removal and rejoin
On 11 July 2017 at 05:49, Zhu, Joshua
<j...@vormetric.com<mailto:j...@vormetric.com>> wrote
I have the following (hypothetical) tables and their relationships (primary
keys are in square brackets):
[server_id] [device_id][sensor_id][property_id]
SERVER --- 1:n --- DEVICE --- 1:n --- SENSOR --- 1:n --- PROPERTY
| |
New to this group, so if this is not the right place to ask this question or it
has been asked before/documented, please kindly point me the right group or the
right thread/documentation, thanks.
A BDR novice, I would like to know how BDR replicate changes among nodes in a
BDR group, let's say
tream" nodes was used, and I am not clear what
that meant in the context of a mesh-connected group]
Thanks again
-Original Message-
From: Craig Ringer [mailto:cr...@2ndquadrant.com]
Sent: Wednesday, June 07, 2017 5:59 PM
To: Zhu, Joshua <j...@thalesesec.net>
Cc: pgsql-genera
Hi, I am experimenting how network configuration impacts BDR replication, ran
into something that I can't explain, and wonder if someone can shed light.
Here it goes:
With a four node BDR group configured and running (all using default port
5432), I purposely blocked port 5432 on one of the
Thought about that possibility, so postgres on the node with port blocked was
restarted after blocking the port.
-Original Message-
From: Alvaro Aguayo Garcia-Rada [mailto:aagu...@opensysperu.com]
Sent: Friday, August 25, 2017 3:23 PM
To: Zhu, Joshua <j...@thalesesec.net>
Cc: Post
Thanks for the idea, and that is it... it's indeed the other direction of
replication was affected by blocking a port
-Original Message-
From: Alvaro Aguayo Garcia-Rada [mailto:aagu...@opensysperu.com]
Sent: Friday, August 25, 2017 5:00 PM
To: Zhu, Joshua <j...@thalesesec.net&
Database oid is used in both bdr.bdr_nodes, as node_dboid, and
bdr.bdr_connections, as conn_dboid, also used in construction of replication
slot names.
I noticed that when trying to join a bdr group, if the database oid on the new
node happens to be the same as that of an node already in the
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Craig Ringer
Sent: Thursday, October 26, 2017 7:24 PM
To: Zhu, Joshua <j...@thalesesec.net>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] BDR question on dboid conflicts
On 27 October 2017 at 01:15, Zhu, Joshua <j...@vormetric.c
12 matches
Mail list logo