[Pgpool-general] Is pgpool compatible with protocolVersion=3 ofjdbc?

[Daniel.Crespo at l-3com.com]

Are you able to create a table running slony-I (without using pgpool)?
AFAIK, you can not create tables by issuing SQL statements to an open
session of postgresql when it's being replicated by slony-I.

 

Daniel

 

From: pgpool-general-bounces at pgfoundry.org
[mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of Nimesh Satam
Sent: Friday, August 28, 2009 12:32 AM
To: Tatsuo Ishii
Cc: pgpool-general at pgfoundry.org
Subject: Re: [Pgpool-general] Is pgpool compatible with
protocolVersion=3 ofjdbc?

 

Hi Tatsuo,

Can you please let us know what might be going wrong here or if you need
any further information?

Regards,
Nimesh.

On Wed, Aug 26, 2009 at 10:07 AM, Nimesh Satam <nimesh.satam at gmail.com>
wrote:

Tatsuo,



>> What error do you have with temp table creation?

When we try to create temp table using pgpool, the application fails
with below error:

"ERROR: kind mismatch among backends. Possible last query was: "..."
kind details are: 0[1] 1[E]" error.

We are using pgpool in master-slave mode and loadbalance=on.

On execution of the below queries the above error appears:

1) CREATE TEMP TABLE tmp_ch (key integer PRIMARY KEY); 

2) INSERT INTO tmp_ch (key) SELECT key FROM rpt_ch WHERE id IN (135848,
135841); 

Note: in logs we see the first query getting Parsed on master and slave
database. But the execute is done only on slave. As a result the 2 query
fails.

Let me know if you need any information

Regards,
Nimesh.





On Wed, Aug 26, 2009 at 5:52 AM, Tatsuo Ishii <ishii at sraoss.co.jp>
wrote:

> Is there any significant difference in using pg connection string
> "protocolVersion=2"?
>
> By default pg driver uses protocol V3, this causes the temp table
creation
> from application to fail.

What error do you have with temp table creation?


> If we change the connection string to
> "protocolVersion=2" everything works fine
>
> eg: Connection c =
>
DriverManager.getConnection("jdbc:postgresql://db_host:db_port/reporting
?protocolVersion=2","car",
> "");
>
> Is there any negative impact of using protocolversion 2.

Yes. Protocolversion 2 is inefficient comparing with 3. Also you will
lose some important features those are available with only 3. For
example, load balance, insert lock etc.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090828/f5ea8a4f/attachment.html>