adding a bdr node using bcv backup - Mailing list pgsql-general

From (Daniel Stolf)
Subject adding a bdr node using bcv backup
Date
Msg-id CABfnVgUj24yWfA9ztDbkCJpYNpejLfL6uq830+KdjBn=9vnkdQ@mail.gmail.com
Whole thread Raw
Responses Re: adding a bdr node using bcv backup
List pgsql-general
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

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: How to stop autovacuum for daily partition old tables
Next
From: Melvin Davidson
Date:
Subject: Re: How to stop autovacuum for daily partition old tables