BUG #6098: pgcluster

From: "wbc" <wbc_512(at)163(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6098: pgcluster
Date: 2011-07-08 07:56:12
Message-ID: 201107080756.p687uCmL005143@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6098
Logged by: wbc
Email address: wbc_512(at)163(dot)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库中,请问需要调整什么参数?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message zhaowy 2011-07-08 08:20:45 BUG #6099: Does pgcluster support hibernate?
Previous Message Maxim Boguk 2011-07-08 06:46:29 BUG #6097: Server crash when enabling custom_variable_classes