[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

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 adrian.kla...@aklaver.com: 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

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

2014-07-18 Thread Martin Gudmundsson
18 jul 2014 kl. 17:31 skrev Dennis Jenkins dennis.jenkins...@gmail.com: On Fri, Jul 18, 2014 at 10:16 AM, Andrew Pennebaker andrew.penneba...@gmail.com 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

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 only

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-14 Thread Martin Gudmundsson
13 jul 2014 kl. 21:54 skrev Martin Gudmundsson martingudmunds...@gmail.com: 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

[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

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 martingudmunds...@gmail.com: Hi! I wanted to test synchronous bi-dircetional replication

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 04:58 skrev Craig Ringer cr...@2ndquadrant.com: 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

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 anomalies,

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 13:45 skrev Andres Freund and...@2ndquadrant.com: On 2014-07-12 13:23:08 +0200, Martin Gudmundsson wrote: 12 jul 2014 kl. 12:33 skrev Andres Freund and...@2ndquadrant.com: On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: On 07/12/2014 02:24 PM, Martin Gudmundsson wrote

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 Failover

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 14:48 skrev Andres Freund and...@2ndquadrant.com: 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

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 12:33 skrev Andres Freund and...@2ndquadrant.com: 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

[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