Обсуждение: adding a bdr node using bcv backup

Поиск
Список
Период
Сортировка

adding a bdr node using bcv backup

От
"(Daniel Stolf)"
Дата:
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...

What I wanted to know is if I can leverage a bcv backup... Is it possible?

I have a 2 nodes on my test environment and wanted to add a 3rd using this approach... But when I restored the backup, the bdr information from node1 went along, so when I use 'bdr.bdr_group_join', it tells me:
ERROR:  This node is already a member of a BDR group
HINT:  Connect to the node you wish to add and run bdr_group_join from it instead