Re: [Pgpool-general] Can we launch multiple pgpool instances in one host?

2011-01-20 Thread Tatsuo Ishii
Hi All, Can we install mutliple copies of pgpool in different locations in one machine, e.g, /opt/pgpool-0, /opt/pgpool-1, /opt/pgpool-2, ..., and launch all instances simutanously(of course in diffrent ports)? As long as you use different ports logging directory and so on, ok. The

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

2011-01-20 Thread Glyn Astill
Hi Toshihiro, How did you get on with this? Is there anything I can provide to help? Glyn --- On Tue, 18/1/11, Toshihiro Kitagawa kitag...@sraoss.co.jp wrote: From: Toshihiro Kitagawa kitag...@sraoss.co.jp Subject: Re: [Pgpool-general] pool_add_prepared_statement: prepared statement

Re: [Pgpool-general] Query regarding load balancing

2011-01-20 Thread Sandeep Thakkar
But, when I write the insert statement in a function, pgpool sends it to the slave. Why? create table spl_tbl(j int); create function plpgsql_testfunc(i int) returns int language plpgsql as $$ declare col int; begin --for i in 1..10 loop insert into spl_tbl values

Re: [Pgpool-general] Query regarding load balancing

2011-01-20 Thread Tatsuo Ishii
You need to tell pgpool that your function is writing to DB. Please refer to black_function_list directive of pgpool.conf. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp But, when I write the insert statement in a function,

[Pgpool-general] pgpool hangs when set insert_lock false

2011-01-20 Thread Zhidong She
Hi guys, I'm using pgbench to benchmark the pgpool. In order to avoid table lock, I tried to set insert_lock as false, but it caused pgpool hang. If I set insert_lock back to true, it works fine. Do we have to set insert_lock true? Any suggestions? Thanks for your time! Br, Zhidong

[Pgpool-general] Multi-Master?

2011-01-20 Thread CS DBA
Hi List; It seems that setting replication_mode = true will produce a single master/multiple slaves scenario. Does PGPOOL support multi-master replication? Thanks in advance ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org

[Pgpool-general] pcp_recovery_node

2011-01-20 Thread Armin Nesiren
Hi to everyone, I'm having problem with pcp_recovery_node. I have 3 computer architecture. One computer is with installed pg_pool, and two other are nodes. Pg_pool version installed is 3.0.1, and postgres is 9.0.2 I have streaming replication configured. I'm trying to setup automatic recovery of

[Pgpool-general] Setting up PGpool with PostgreSQL 9.0

2011-01-20 Thread Matthew Bennett
I am setting up PGpool with PostgreSQL 9.0 using streaming replication. I want to use PGpool to load balance between the live database and the hot-standby. The two Postgres servers are running on their own machines and PGpool is running on it's own server. I think I have everything set up

Re: [Pgpool-general] Setting up PGpool with PostgreSQL 9.0

2011-01-20 Thread Guillaume Lelarge
Le 20/01/2011 23:58, Matthew Bennett a écrit : I am setting up PGpool with PostgreSQL 9.0 using streaming replication. I want to use PGpool to load balance between the live database and the hot-standby. The two Postgres servers are running on their own machines and PGpool is running on

Re: [Pgpool-general] Setting up PGpool with PostgreSQL 9.0

2011-01-20 Thread Matthew Bennett
Guillaume Lelarge guillaume@... writes: Can you show us your pgpool.conf file? It is a the stock pgpool.conf file except for the following changes: socket_dir = '/var/run' pcp_socket_dir = '/var/run' logdir = '/mnt/pgpool' master_slave_mode = true master_slave_sub_mode = 'stream'

Re: [Pgpool-general] Setting up PGpool with PostgreSQL 9.0

2011-01-20 Thread Matthew Bennett
Matthew Bennett mbennett@... writes: It is a the stock pgpool.conf file except for the following changes: socket_dir = '/var/run' pcp_socket_dir = '/var/run' I figured out the problem. The socket_dir and pcp_socket_dir needed to be set to /tmp. Sorry about that.

Re: [Pgpool-general] Multi-Master?

2011-01-20 Thread Tatsuo Ishii
It seems that setting replication_mode = true will produce a single master/multiple slaves scenario. Does PGPOOL support multi-master replication? You can create multi-master like set up. If you have 2 servers: server1: pgpool connects to PostgreSQL running on server1 and server2

Re: [Pgpool-general] pgpool hangs when set insert_lock false

2011-01-20 Thread Tatsuo Ishii
I'm using pgbench to benchmark the pgpool. In order to avoid table lock, I tried to set insert_lock as false, but it caused pgpool hang. If I set insert_lock back to true, it works fine. Do we have to set insert_lock true? Any suggestions? Can you show us pgpool version, pgbench arguments,

Re: [Pgpool-general] pcp_recovery_node

2011-01-20 Thread Tatsuo Ishii
I'm having problem with pcp_recovery_node. I have 3 computer architecture. One computer is with installed pg_pool, and two other are nodes. Pg_pool version installed is 3.0.1, and postgres is 9.0.2 I have streaming replication configured. I'm trying to setup automatic recovery of nodes. I

Re: [Pgpool-general] pcp_recovery_node

2011-01-20 Thread Armin Nesiren
Actually, yesterday in desperate moments I have done that, I got cvs version of pgpool. I think I have same situation. I have added failback script that creates trigger file on my new primary node, but standby is acting like primary.. On Fri, Jan 21, 2011 at 8:19 AM, Tatsuo Ishii

Re: [Pgpool-general] pcp_recovery_node

2011-01-20 Thread Tatsuo Ishii
Ok. Can you show the pgpool log and PostgreSQL log(both node 0 and 1) when you did: pcp_recovery_node 20 localhost 9898 postgres password 0 -d -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Actually, yesterday in desperate