Hi Craig, how are you?
Just as an update, I figured it out...
First, here's my setup:
Node 1 and Node 2 running postgresql-bdr94-bdr and bdr enabled.
Node 3 with the same setup, ready to receive the snapshot clone.
These were my steps:
1) pg_start_backup
2) take snapshot from Node 1
3) pg_stop_b
On 21 January 2016 at 20:46, (Daniel Stolf) wrote:
> So here's what I don't get:
>
> 1) if I have to create a new replication slots on node1 and 2 beforehand
> using "pg_create_physical_replication_slot" , don't they need the if of
> node3 on their name?
>
You need to create a logical replicati
I'm sorry, I didn't send the correct information about node 2...
Here's what I get on all three nodes after I take a snapshot on node 1 and
bring it up on node 3...
*=== On Node 1: ===*
bdrdemo=# select bdr.bdr_get_local_nodeid();
bdr_get_local_nodeid
---
(*62393
Ok, I'm at work now and I have access to my lab...
* On Node 1: *
bdrdemo=# select bdr.bdr_get_local_nodeid();
bdr_get_local_nodeid
---
(6239328434665526195,1,16385)
(1 row)
bdrdemo=# select bdr.bdr_get_local_node_name();
bdr_get_local_node_name
Hi Craig, how are you?
Thanks for your answer. It doesn't seems too complex... Also, it's just a
test scenario, I don't intend to use as a production setup or to recommend
as such, at least not until I'm 100% sure I got it right...
So, assuming I get the snapshot right... The steps would be...
1
On 21 January 2016 at 08:29, (Daniel Stolf) wrote:
> Hello there...
>
> I'm new to postgres and I'm trying out BDR replication...
>
> I know that when I issue the bdr.bdr_group_join command, it will copy the
> entire database from the host I specify on parameter 'join_using_dsn' and
> this may ta
Hello there...
I'm new to postgres and I'm trying out BDR replication...
I know that when I issue the bdr.bdr_group_join command, it will copy the
entire database from the host I specify on parameter 'join_using_dsn' and
this may take a while depending on the network and the size of the
database.
Hello there...
I'm new to postgres and I'm trying out BDR replication...
I know that when I issue the bdr.bdr_group_join command, it will copy the
entire database from the host I specify on parameter 'join_using_dsn' and
this may take a while depending on the network and the size of the
database.
