Re: [GENERAL] BDR: Can a node live alone after being detached

2015-06-25 Thread Sylvain MARECHAL
Le 26/06/2015 03:26, Craig Ringer a écrit : [...] Sorry to bother again about that, but what about the "detached node cleanup" best practice? Suppose I have 2 nodes, 'node1' and 'node2'. So I am OK to call bdr_part_by_node_names('node2') on node1 to detach node2. But then, is it safe to call bd

Re: [GENERAL] BDR: Can a node live alone after being detached

2015-06-25 Thread Craig Ringer
On 26 June 2015 at 04:59, Sylvain MARECHAL wrote: > >> >> You shouldn't part a node from its self. The next revision will >> >> prevent this with an error. >> > >> > >> > Ok, this was not clear for me. >> >> Or anyone else, hence the coming docs and code changes. >> > Sorry to bother again about t

Re: [GENERAL] BDR: Can a node live alone after being detached

2015-06-25 Thread Sylvain MARECHAL
> >> You shouldn't part a node from its self. The next revision will > >> prevent this with an error. > > > > > > Ok, this was not clear for me. > > Or anyone else, hence the coming docs and code changes. > > Sorry to bother again about that, but what about the "detached node cleanup" best practice

Re: [GENERAL] BDR: Can a node live alone after being detached

2015-06-16 Thread Craig Ringer
On 16 June 2015 at 18:40, Sylvain MARECHAL wrote: > Nothing special in the logs here. What I would like to emphasize is that a > single node can not live alone. Yes, that's right. "Single node BDR", i.e. running with BDR enabled but no peers, would be nice to support for testing and robustness

Re: [GENERAL] BDR: Can a node live alone after being detached

2015-06-16 Thread Sylvain MARECHAL
Hi Craig, Thanks for your response. Le 16/06/2015 03:58, Craig Ringer a écrit : On 15 June 2015 at 17:19, Sylvain MARECHAL wrote: Is it possible to completely detach a node so that it can live alone Yes. On a different node to the one you want to remove, bdr.bdr_part_by_node_names(ARRAY['the

Re: [GENERAL] BDR: Can a node live alone after being detached

2015-06-15 Thread Craig Ringer
On 15 June 2015 at 17:19, Sylvain MARECHAL wrote: > Is it possible to completely detach a node so that it can live alone Yes. On a different node to the one you want to remove, bdr.bdr_part_by_node_names(ARRAY['the_node_to_remove']) to safely remove it without disrupting the other nodes. > in p

[GENERAL] BDR: Can a node live alone after being detached

2015-06-15 Thread Sylvain MARECHAL
Hello all, Is it possible to completely detach a node so that it can live alone, in particular that DDL are again possible on that node? I tried with a simple node without success: <<< postgres=# create database test template template0; CREATE DATABASE postgres=# \c test You are now connected