[pgpool-general: 2589] Re: pgpool with JDBC for load balancing
anumr_0123 at yahoo.com
Thu Feb 20 08:52:32 JST 2014
Will post it, say the next week end. I dont have one handy, as I was in a hurry to get this setup for a customer. Will prepare one and post it.
On Tuesday, February 18, 2014 8:05 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
Can you please provide self-contained test case?
SRA OSS, Inc. Japan
> I did as you suggested. But no every update to the database fails with
> "unnamed prepared statement does not exist"
> Here is my setup.
> I have host db1 running postgresql 9.1 (master)
> host db2 running postgresql 9.1 (slave)
> Postgres Streaming replication is setup between the 2 servers
> Pgpool is running on a separate host pgp3 with
> load_balance_mode = on
> master_slave_mode = on
> master_slave_sub_mode = 'stream'
> replication_mode = off
> I have tried with 3.1.10, 3.2.7 and 3.3.2 all with same result.
> I have attached my pgpool.conf and the debug logs I get for 3.1.10 and 3.3.2
> Can you please help ?
> Is there a minimal working java application (may be a test case ?) I can get that can demonstrate that pgpool works with jdbc drivers / load balancing and postgres streaming replication ?
> Thanks for your help.
> On Thursday, February 13, 2014 10:36 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> Recently a bug which might be related to your report was found:
> Please grab 3.3-stable head and try again.
> Best regards,
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>> I have to setup pgpool for load balancing only and it has to work with an web application in Java.
>> There are several posts on the net as well as mailing lists regarding the problems with this setup, yet nothing conclusive. All that I have tried so far has only led me to
>> "unnamed prepared statement does not exist"
>> So my question is -
>> 1) Is there a checklist of things that I need to do to get pgpool load balancing to work with simple JDBC connection with Postgres 9.1 in stream replication / hotstandby mode.
>> 2) Is there a anything test case or something that can demonstrate that pgpool indeed works with JDBC in load balancing mode.
>> I don't need any other capability of pgpool - no connection pool, replication, parallel query, nothing at all.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general