BUG #6098: pgcluster - Mailing list pgsql-bugs

From wbc
Subject BUG #6098: pgcluster
Date
Msg-id 201107080756.p687uCmL005143@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6098: pgcluster
List pgsql-bugs
The following bug has been logged online:

Bug reference:      6098
Logged by:          wbc
Email address:      wbc_512@163.com
PostgreSQL version: 8.3.8
Operating system:   linux5.5
Description:        pgcluster
Details:

软件环境:
pgcluster-1.9.0rc7.tar.gz;postgresql-8.3.6.tar.bz2,

问题一:用用pgcluster做集群,如何只复制行级锁查询。
目前所有select语句都会复制,我只想让select .... from table
for update 这种语句才复制。
问题二:用pgcluster做集群,应用通过hibernate3实现,发现如
下问题,求解:
1.在访问数据库时发先一个奇怪的问题,当hibernate配置文ä»
¶æ—¶è®¾ç½®hibernate.jdbc.fetch_size属性时无法访问数据,程序就è¢
«æŒ‚死在那,当注释掉该配置时,一切恢复正常
2.应用是通过连接池与数据库建立长连接,但过了一段时é—
´æ•°æ®åº“自动会杀掉所有链接
问题三:用pgcluster做集群,如何只复制行级锁查询。
用pgcluster做集群,有两个库分别为A、B,但在A库执行一个s
elect,居然也分发到B库中,请问需要调整什么参数?

pgsql-bugs by date:

Previous
From: kmx
Date:
Subject: PostgreSQL fails to build with 32bit MinGW-w64
Next
From: ""
Date:
Subject: BUG #6099: Does pgcluster support hibernate?