atom feed3 messages in org.postgresql.pgsql-jdbcRe: jdbc 8.n driver / pgcluster problem
FromSent OnAttachments
Christian DannemannSep 20, 2006 8:42 am 
Kris JurkaSep 20, 2006 7:45 pm 
Oliver JowettSep 20, 2006 7:50 pm 
Subject:Re: jdbc 8.n driver / pgcluster problem
From:Oliver Jowett (oli@opencloud.com)
Date:Sep 20, 2006 7:50:58 pm
List:org.postgresql.pgsql-jdbc

Christian Dannemann wrote:

To whom it may concern:

We have installed pgcluster (1.3 with postgres 8.0.1) and are currently testing it as we want to use it for a client in a production environment.

Apparently, pgcluster's replication only works when using jdbc driver < 8.0, so 7.4 works fine and all database changes submitted to one database are replicated across the cluster without any problem.

When we use the 8.0 driver, the changes only go to the database that we connect to and are not replicated to the cluster.

I was wondering if this problem is known and if yes, if there is a plan to fix it (either in the jdbc driver or in pgcluster).

The main change between the 7.4 and 8.0 drivers was a change to use the extended query protocol instead of the simple query protocol. Perhaps pgcluster does not support the extended query protocol correctly?

-O