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 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 momen

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 wrote: > > I'm

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 nod

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 argumen

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 s

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

2011-01-20 Thread Matthew Bennett
Matthew Bennett 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] Setting up PGpool with PostgreSQL 9.0

2011-01-20 Thread Matthew Bennett
Guillaume Lelarge 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' pgpool2_hostname =

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

[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 correctly

[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] 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 http://pgfou

[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 _

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, pgp

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 (1);

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 wrote: > From: Toshihiro Kitagawa > Subject: Re: [Pgpool-general] pool_add_prepared_statement: prepared statement > already exists > To: "Glyn Astill" > Cc: pgpo

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 c