[Pgpool-general] Why need set 'slony' submode in pgpool.conf

2011-01-12 Thread Zhidong She
Hi Guys, I'm just a little confused about master_slave_sub_mode option in configuration file. If we build a master/slave db replication and deploy pgpool on top of them, we need set master_slave_mode to true. It does make sence. But why does PgPool need to set slony sub mode? What's the purpose

Re: [Pgpool-general] query regarding connection pooling

2011-01-12 Thread Sandeep Thakkar
From: Tatsuo Ishii is...@sraoss.co.jp To: sandee...@yahoo.com Cc: pgpool-general@pgfoundry.org Sent: Wed, January 12, 2011 2:00:11 PM Subject: Re: [Pgpool-general] query regarding connection pooling That means, even if the free connection is available in

Re: [Pgpool-general] query regarding connection pooling

2011-01-12 Thread Sandeep Thakkar
Yes, that is true. I agree. Thanks Tatsuo. From: Tatsuo Ishii is...@sraoss.co.jp To: sandee...@yahoo.com Cc: pgpool-general@pgfoundry.org Sent: Wed, January 12, 2011 2:00:11 PM Subject: Re: [Pgpool-general] query regarding connection pooling That means, even

Re: [Pgpool-general] Why need set 'slony' submode in pgpool.conf

2011-01-12 Thread Guillaume Lelarge
Le 12/01/2011 09:40, Zhidong She a écrit : Hi Guys, I'm just a little confused about master_slave_sub_mode option in configuration file. If we build a master/slave db replication and deploy pgpool on top of them, we need set master_slave_mode to true. It does make sence. But why does

Re: [Pgpool-general] pool_add_prepared_statement: prepared statement already exists

2011-01-12 Thread Glyn Astill
Any luck with this? --- On Tue, 11/1/11, Glyn Astill glynast...@yahoo.co.uk wrote: From: Glyn Astill glynast...@yahoo.co.uk Subject: Re: [Pgpool-general] pool_add_prepared_statement: prepared statement already exists To: Toshihiro Kitagawa kitag...@sraoss.co.jp Cc:

[Pgpool-general] replication/failover feature in Master/Slave mode

2011-01-12 Thread Sandeep Thakkar
Hi, I have a primary and a standby server on different boxes and both are running on different ports. I would like to use pgpool for Streaming Replication and Failover. Hence, I selected Master/Slave mode with stream. Now, I have a question, if I write anything on primary, how will the data

Re: [Pgpool-general] replication/failover feature in Master/Slave mode

2011-01-12 Thread Guillaume Lelarge
Hi, Le 12/01/2011 15:10, Sandeep Thakkar a écrit : [...] I have a primary and a standby server on different boxes and both are running on different ports. I would like to use pgpool for Streaming Replication and Failover. Hence, I selected Master/Slave mode with stream. Now, I have a