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库中,请问需要调整什么参数?
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 |