[GENERAL] hstore/jsonb support in hibernate/JPA

2014-07-22 Thread Martin Gudmundsson
Hi all! I saw that Rails 4 comes with hstore support out of the box. Does anyone know if there’s any integrated support like that in hibernate or any other JPA implementation? I know your able to write your own custom datatypes, but I’m looking for integrated standardized support in the base lib

Re: [GENERAL] Petition: Treat #!... shebangs as comments

2014-07-18 Thread Martin Gudmundsson
18 jul 2014 kl. 17:31 skrev Dennis Jenkins : > On Fri, Jul 18, 2014 at 10:16 AM, Andrew Pennebaker > wrote: > Could we please have the PostgreSQL lexer treat #!... on the first line of a > file as a comment? This would enable .psql scripts to be run with dot-slash > notation preferred by many

Re: [GENERAL] Petition: Treat #!... shebangs as comments

2014-07-18 Thread Martin Gudmundsson
+1 Skickat från min iPhone > 18 jul 2014 kl. 17:58 skrev Adrian Klaver : > >> On 07/18/2014 08:52 AM, Karsten Hilbert wrote: >> On Fri, Jul 18, 2014 at 08:32:53AM -0700, Adrian Klaver wrote: > >> >> I think the OP is talking about executable scripts so both of >> >>$> psql -f the-file.sql

Re: [GENERAL] BDR: Strange values in pg_stat_replication

2014-07-14 Thread Martin Gudmundsson
Hi! Never mind this one. Wrong config of synchronous replication by me. It looks good once I got the replication setup correctly. Kind regards, Martin 13 jul 2014 kl. 23:10 skrev Martin Gudmundsson : > Hi! > I wanted to test synchronous bi-dircetional replication

[GENERAL] BDR: Strange values in pg_stat_replication

2014-07-14 Thread Martin Gudmundsson
Hi! I wanted to test synchronous bi-dircetional replication using synchronous_standby_names with bdr. So I set this up as follows: Node alpha has the following settings in postgresql.conf port=5432 wal_level = 'logical' max_replication_slots = 3 max_wal_senders = 4 synchronous_standby_names=’bet

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-14 Thread Martin Gudmundsson
13 jul 2014 kl. 21:54 skrev Martin Gudmundsson : > >> I think we (as in postgres) will probably get the ability to run >> individual transactions in such a mode, but you surely wouldn't want to >> run every transaction in it. >> > > So, would then

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-14 Thread Martin Gudmundsson
> I think we (as in postgres) will probably get the ability to run > individual transactions in such a mode, but you surely wouldn't want to > run every transaction in it. > So, would then these transactions be ”2-phase”? I mean either all nodes commit the transaction or none of them do? Or o

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 wor

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 >>> l

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 th

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 Gudmun

[GENERAL] Bi-Directional replication client awareness

2014-07-11 Thread Martin Gudmundsson
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 relevant for other drivers as well. Or is the long term plan that we need we need to rely on middleware like pgpo