[pgpool-general: 331] Re: Transaction replicated to streaming slave

Tatsuo Ishii ishii at postgresql.org
Sat Mar 31 09:47:27 JST 2012


> AWESOME!! IT WORKS!
> 
> Thanks so much Tatsuo.

Glad to hear that and you are welcome. I'm going to commit this to
master and 3.1 stable.

> Just so you know, I'm seeing this on the slave:
> BEGIN
> COMMIT
> BEGIN
> COMMIT
> 
> I know that has no impact, and I'm guessing that is for the JDBC driver,
> but I wanted to make sure you were aware of that behavior.

Yes, this is an expected behavior. Pgpool always open an explicit
transaction on every node.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> On 3/30/12 2:16 AM, Tatsuo Ishii wrote:
>> Ok, here is the patch for pool_query_context.h.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>> 


More information about the pgpool-general mailing list