Re: [GENERAL] BDR global sequences in two machine failover

2015-09-08 Thread Giovanni Maruzzelli
Thanks again and more Craig -giovanni On Tue, Sep 8, 2015 at 8:31 AM, Craig Ringer wrote: > On 7 September 2015 at 20:56, Giovanni Maruzzelli > wrote: > > > If I do not use global sequences, and I use uuid as primary keys, would > BDR > > be a correct choice? > > For something like a VoIP ser

Re: [GENERAL] BDR global sequences in two machine failover

2015-09-07 Thread Craig Ringer
On 7 September 2015 at 20:56, Giovanni Maruzzelli wrote: > If I do not use global sequences, and I use uuid as primary keys, would BDR > be a correct choice? For something like a VoIP service where eventual consistency is usually OK and geographic redundancy with latency tolerance and partition

Re: [GENERAL] BDR global sequences in two machine failover

2015-09-07 Thread Giovanni Maruzzelli
On Sep 7, 2015 5:05 AM, "Craig Ringer" wrote: > > On 7 September 2015 at 00:18, Giovanni Maruzzelli wrote: > > Hello, > > > > Typical HA situation. > > > > I have master-master, two only machines, one active and one passive > > (standby) with floating IP. > > I write to only one machine at time,

Re: [GENERAL] BDR global sequences in two machine failover

2015-09-06 Thread Craig Ringer
On 7 September 2015 at 00:18, Giovanni Maruzzelli wrote: > Hello, > > Typical HA situation. > > I have master-master, two only machines, one active and one passive > (standby) with floating IP. > I write to only one machine at time, the one with the floating IP. This is a deployment that is bette

[GENERAL] BDR global sequences in two machine failover

2015-09-06 Thread Giovanni Maruzzelli
Hello, Typical HA situation. I have master-master, two only machines, one active and one passive (standby) with floating IP. I write to only one machine at time, the one with the floating IP. I have one column that is a serial from a global sequence in BDR. When one machine is down I can no mor

Re: [GENERAL] BDR Global Sequences

2014-09-30 Thread pbj
Hi Andres, > Hi, > > On 2014-09-29 13:52:52 -0700, p...@cmicdo.com wrote: >> I have a question about BDR Global Sequences. >> [deleted] >> Is there way to increase a global sequence's reservation block for each >> node so that I can tell the nodes, "I'm going to load 100M rows now so >> yo

Re: [GENERAL] BDR Global Sequences

2014-09-30 Thread Andres Freund
Hi, On 2014-09-29 13:52:52 -0700, p...@cmicdo.com wrote: > I have a question about BDR Global Sequences. > > I've been playing with BDR on PG 9.4beta2, built from source from the > 2nd Quadrant GIT page (git://git.postgresql.org/git/2ndquadrant_bdr.git). > > When trying a 100 row \copy-in, l

[GENERAL] BDR Global Sequences

2014-09-29 Thread pbj
I have a question about BDR Global Sequences. I've been playing with BDR on PG 9.4beta2, built from source from the 2nd Quadrant GIT page (git://git.postgresql.org/git/2ndquadrant_bdr.git). When trying a 100 row \copy-in, letting PG choose the global sequence values, I get "ERROR: could not