Re: BDR: cannot remove node from group

On 2015-09-15 16:45, Florin Andrei wrote:
> On 2015-08-25 18:29, Craig Ringer wrote:
>> On 26 August 2015 at 07:19, Florin Andrei <florin@andrei.myip.org>
>> wrote:
>>
>>> What do I need to do to start over? I want to delete all traces of
>>> the BDR
>>> configuration I've done so far.
>>
>> you need to DROP the database you removed, then re-create it as a new
>> empty database. You cannot re-join a node that has been removed.
>
> postgres=# DROP DATABASE bdrdemo;
> ERROR:  database "bdrdemo" is being accessed by other users
> DETAIL:  There is 1 other session using the database.
>
> Something's holding it open, not sure exactly what.

More specifically, it seems like it's the bgworker that's holding that
DB:

  1123 ?        S      0:00 /usr/lib/postgresql/9.4/bin/postgres -D
/var/lib/postgresql/9.4/main -c
config_file=/etc/postgresql/9.4/main/postgresql.conf
  1124 ?        Ss     0:00  \_ postgres: logger process
  1126 ?        Ss     0:00  \_ postgres: checkpointer process
  1127 ?        Ss     0:00  \_ postgres: writer process
  1128 ?        Ss     0:00  \_ postgres: wal writer process
  1129 ?        Ss     0:00  \_ postgres: autovacuum launcher process
  1130 ?        Ss     0:00  \_ postgres: stats collector process
  1136 ?        Ss     0:00  \_ postgres: bgworker: bdr supervisor
  1137 ?        Ss     0:00  \_ postgres: bgworker: bdr db: bdrdemo

Should I just kill that process, or is there a "nicer" way to do it?

More generally, is there a way to just turn off BDR entirely on one
node? I can't find a clear answer in the documentation to questions like
- how do I turn on or off replication altogether?

--
Florin Andrei
http://florin.myip.org/