Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 12:33 skrev Andres Freund : > On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: >> On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: >>> Any ideas giving BDR an option to be synchronous. I mean in ”close >>> quarters” with low latency it should work ok. >> >> BDR doesn't do sync

[GENERAL] performance monitoring/tuning

2014-07-12 Thread Ramesh T
Hi, How performance monitoring/tuning on postgres..? please let me know some links to learn, ex-query performence, i need it .. thanks in advance, ramesh

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
>> >> I’ve seen some mailing list threads regarding this but was that ever >> implemented? Do you know where it’s documented? > > I don't think the patch ever got accompanying documentation. > > It's not mentioned here, anyway: > > http://jdbc.postgresql.org/documentation/93/connect.html > >

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 14:48 skrev Andres Freund : > On 2014-07-12 14:37:02 +0200, Martin Gudmundsson wrote: >>> It's possible to do it to a streaming replication sync standby, but also >>> to another BDR node. The logical decoding facility added in 9.4 allows >>> logical replication solutions to use th

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 04:58 skrev Craig Ringer : > On 07/12/2014 02:42 AM, Martin Gudmundsson wrote: >> Hi all! >> I was wondering if there are any specific load balancing/failover >> functionality planned for client drivers connection to a BDR group. In my >> case the jdbc driver, but could be relev

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
>> >> Because BDR is asynchronous multi-master _replication_ though, clients >> are expected to be aware of some of the anomalies that can occur. A >> naïve client that just picked a random BDR server and did the next >> transaction on it would be very likely to cause unwanted replication >> anom

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 13:45 skrev Andres Freund : > On 2014-07-12 13:23:08 +0200, Martin Gudmundsson wrote: >> >> 12 jul 2014 kl. 12:33 skrev Andres Freund : >> >>> On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: > Any ideas giving BDR an o

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Andres Freund
On 2014-07-12 14:37:02 +0200, Martin Gudmundsson wrote: > > It's possible to do it to a streaming replication sync standby, but also > > to another BDR node. The logical decoding facility added in 9.4 allows > > logical replication solutions to use the same mechanism as streaming rep > > does. > >

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Michael Paquier
On Sat, Jul 12, 2014 at 7:22 PM, Craig Ringer wrote: > On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: >> 12 jul 2014 kl. 04:58 skrev Craig Ringer : >>> PgJDBC actually already supports rudimentary client-based failover. >> >> I've seen some mailing list threads regarding this but was that ever

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Andres Freund
On 2014-07-12 13:23:08 +0200, Martin Gudmundsson wrote: > > 12 jul 2014 kl. 12:33 skrev Andres Freund : > > > On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: > >> On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: > >>> Any ideas giving BDR an option to be synchronous. I mean in ”close > >>> qu

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Andres Freund
On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: > On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: > > Any ideas giving BDR an option to be synchronous. I mean in ”close > > quarters” with low latency it should work ok. > > BDR doesn't do synchronous replication _yet_, but it's on the roadmap.

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Craig Ringer
On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: > > 12 jul 2014 kl. 04:58 skrev Craig Ringer : > >> PgJDBC actually already supports rudimentary client-based failover. > > I’ve seen some mailing list threads regarding this but was that ever > implemented? Do you know where it’s documented? I

Re: [GENERAL] debugging with gdb

2014-07-12 Thread Michael Paquier
On Fri, Jul 11, 2014 at 11:26 PM, Ravi Kiran wrote: > 13)n In gdb, 'n' or 'next' is used to have the debugger switch to the next line, if you want to stop automatically to the next breakpoint, use either 'c' of 'continue'. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgr