Thread: BUG #6098: pgcluster

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

On 8/07/2011 3:56 PM, wbc wrote:
> 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 is obsolete and abandoned.

Look into Bucardo, Slony-I, pgbouncer, pgpool, etc.

For more questions please try posting on the pgsql-general mailing list
(almost all in english) or in one of the language-specific mailing lists
you'll see here: http://www.postgresql.org/community/lists/ . I don't
see any lists specifically for Chinese (?) but there may be internet
forums or similar dedicated to PostgreSQL in your preferred language.

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088     Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/