Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group